< Int4 - limit >

Started by phpaalmost 25 years ago2 messagesgeneral
Jump to latest
#1phpa
phpa@fish.tm

Hey there,

(using postgres 6.5.0 - on Red Hat Linux)

I have built a small application which has a table for unique identifiers with a column of type int4.

This has one added to it each time a new key is required. I am a little worried that at some point when the limit of int4 is reached the system will fall over. Is this the case or is there a work around.

Thanks for any help.

#2Peter Eisentraut
peter_e@gmx.net
In reply to: phpa (#1)
Re: < Int4 - limit >

phpa writes:

Hey there,

(using postgres 6.5.0 - on Red Hat Linux)

I have built a small application which has a table for unique identifiers with a column of type int4.

This has one added to it each time a new key is required. I am a little worried that at some point when the limit of int4 is reached the system will fall over. Is this the case or is there a work around.

int8

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter