Re: OIDs as keys

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: OIDs as keys
Дата
Msg-id 200302261610.13115.dev@archonet.com
обсуждение исходный текст
Ответ на Re: OIDs as keys  (daniel alvarez <d-alvarez@gmx.de>)
Список pgsql-performance
On Wednesday 26 Feb 2003 2:59 pm, daniel alvarez wrote:
>
> Why should user-defined tables have OIDs by default? Other DBMS use ROWIDs
> as the physical storage location used for pointers in index leafs, but this
> is equivalent
> to Postgres TIDs. To the user an OID column is not different than any other
> column
> he can define himself. I'd find it more natural if the column wasn't there
> at all.

I believe the plan is to phase them out, but some people are using them, so
the default is still to create them. Imagine if you were using OIDs as keys
and after a dump/restore they were all gone...
--
  Richard Huxton

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: OIDs as keys
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: OIDs as keys