Re: IS it a good practice to use SERIAL as Primary Key?

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: IS it a good practice to use SERIAL as Primary Key?
Дата
Msg-id 871wnuw7j2.fsf@gmail.com
обсуждение исходный текст
Ответ на Re: IS it a good practice to use SERIAL as Primary Key?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Ответы Re: IS it a good practice to use SERIAL as Primary Key?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Список pgsql-general
Richard Broersma Jr <rabroersma@yahoo.com> writes:

> "" The type names serial and serial4 are equivalent: both create integer
> columns. The type names bigserial and serial8 work just the same way, except
> that they create a bigint column. bigserial should be used if you anticipate
> the use of more than 231 identifiers over the lifetime of the table.  ""
> http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-SERIAL

What would be those "231 identifiers"?


--
Jorge Godoy      <jgodoy@gmail.com>

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

Предыдущее
От: Alexander Staubo
Дата:
Сообщение: Stuck in "DELETE waiting"
Следующее
От: "Kevin Field"
Дата:
Сообщение: Re: OID Perfomance - Object-Relational databases