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  (Brent Wood <b.wood@niwa.co.nz>)
Список 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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Postgres (selection of thesis topic)
Следующее
От: "Andrej Ricnik-Bay"
Дата:
Сообщение: Re: STDERR vs. SYSLOG logging