Postgres Pro
Downloads
Home   >   mailing lists

Re: IS it a good practice to use SERIAL as Primary Key? - Mailing list pgsql-general

From Jorge Godoy
Subject Re: IS it a good practice to use SERIAL as Primary Key?
Date
Msg-id 871wnuw7j2.fsf@gmail.com
Whole thread Raw
In response to Re: IS it a good practice to use SERIAL as Primary Key?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: IS it a good practice to use SERIAL as Primary Key?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Alexander Staubo
Date:
Subject: Stuck in "DELETE waiting"
Next
From: "Kevin Field"
Date:
Subject: Re: OID Perfomance - Object-Relational databases