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 [email protected]
Whole thread Raw
In response to Re: IS it a good practice to use SERIAL as Primary Key?  (Richard Broersma Jr <[email protected]>)
Responses Re: IS it a good practice to use SERIAL as Primary Key?
List pgsql-general
Tree view 
Richard Broersma Jr <[email protected]> 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      <[email protected]>

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