Re: Using oid as pkey

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Using oid as pkey
Дата
Msg-id 449E8EE1-EB20-4AB0-8D4E-FEDB99611D31@seespotcode.net
обсуждение исходный текст
Ответ на Using oid as pkey  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: Using oid as pkey
Re: Using oid as pkey
Список pgsql-general
On Aug 20, 2007, at 16:58 , Ed L. wrote:

> What are the concerns with using oid as the column for a primary
> key declaration for use in trigger-based replication?

Just don't. oids are intended to be used by the database server
itself rather than as part of the user-defined data. If you're
looking for a auto-generated integer to use as a primary key, use
SERIAL. You'd have to specify your table WITH OIDS anyway as they're
no longer used by default for table rows, so there's really nothing
to be gained by using oids.

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: "Ed L."
Дата:
Сообщение: Using oid as pkey
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Using oid as pkey