Re: special columns

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: special columns
Дата
Msg-id 20030402002133.GC17833@svana.org
обсуждение исходный текст
Ответ на special columns  ("Michal Adamczak" <pokryfka@druid.if.uj.edu.pl>)
Список pgsql-general
On Thu, Mar 27, 2003 at 10:49:42PM +0100, Michal Adamczak wrote:
> can oid, ctid, ...
> be a replacement for an int (like serial) primary key?

Well, OIDs are not guarenteed to be unique (or even present) and CTIDs
change everytime you update the row or vacuum or whenever.

The answer is probably no. SERIALs are much better.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Вложения

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Postgres logs
Следующее
От: "Roman Fail"
Дата:
Сообщение: Temporary Tables