Re: OIDS

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: OIDS
Дата
Msg-id 20060519154518.GA19641@wolff.to
обсуждение исходный текст
Ответ на OIDS  (Q Beukes <pgsql-novice@postgresql.org>)
Список pgsql-novice
On Wed, May 17, 2006 at 14:21:47 +0200,
  Q Beukes <pgsql-novice@postgresql.org> wrote:
> Hey,
>
> I have a few questions/thoughts about OIDS.
>
> 1. What are the pros/cons of having them against not having them in your
> table.

Generally you don't want to use them. Use sequences/serial instead.

> 2. Are they unique throughout tables/database/postgres setup.

No. If you want to enforce uniqueness, you need to add a constraint and be
prepared to retry on failures.

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

Предыдущее
От: Verena Ruff
Дата:
Сообщение: Re: select count(*) and limit
Следующее
От: kmh496
Дата:
Сообщение: send psql output to file and setting pager=more