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 [EMAIL PROTECTED] --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
