On Thu, Jan 13, 2005 at 02:48:47PM -0600, Scott Marlowe wrote: > On Thu, 2005-01-13 at 11:08, KÖPFERL Robert wrote:
> > suppose I have a let's say heavy used table. There's a column containing > > UNIQUE in4 > > values. The data type musn't exceed 32-Bit. Since however the table is heavy > > used 2^32 will be reached soon and then? There are far less than 4G-records > > saved thus these values may be reused. How can this be accomplished? > > > > I already defined a sequence but then? > > Redefine it as a bigserial? That would violate the 32-bit requirement since bigserial would make the field a bigint (64 bits). Or am I missing something? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
