Re: OIDs as keys

Поиск
Список
Период
Сортировка
Искать
От
Richard Huxton
Тема
Re: OIDs as keys
Дата
Msg-id
200302261610.13115.dev@archonet.com
Ответ на
Re: OIDs as keys (daniel alvarez)
Список
Дерево обсуждения
Re: OIDs as keys daniel alvarez <d-alvarez@gmx.de>
Re: OIDs as keys Tom Lane <tgl@sss.pgh.pa.us>
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
FAQ