Re: Utility of OIDs in postgres

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Utility of OIDs in postgres
Дата
Msg-id 463842D4.3030407@archonet.com
обсуждение исходный текст
Ответ на Utility of OIDs in postgres  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
Ответы Re: Utility of OIDs in postgres
Список pgsql-general
Jasbinder Singh Bali wrote:
> Hi,
>
> What would be the benefit of creating tables with OIDs as against one's not
> with OIDs
> Giving a unique identifier to each row inserted has some extra efficiency
> factor involved or what.

OIDs are used by the various system tables.
Historically, all user tables had them too.
There's no reason to use them in a new system - they offer no advantages
over an ordinary integer primary-key.

--
   Richard Huxton
   Archonet Ltd

В списке pgsql-general по дате отправления: