Re: Auto incrementing primary keys

On 18/02/2008 17:46, Raymond O'Donnell wrote:

> Well, that depends on your usage, so only you can answer that. According
> to the docs, "serial" creates an integer column,  which will give you
> 2147483647 values - how quickly will you use that lot up? If you think
> you will run out, by all means use bigserial.

Actually, that isn't quite right - just looked at the docs for CREATE
SEQUENCE, and the default maximum value is 2^63-1.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------