I have a table in our DB that functions as a queue with a SERIAL column for
its primary key. At 4am this weekend I started getting the error:
ERROR: integer out of range
Which was attributed to the sequence incrementing past the size of the int4
serial column after several years of operation.
I was able to set the sequence back to 1 and everything was happy.
I was wondering if the SERIAL column should set the MAXVAL=2147483647 when
it creates the sequence?
I ended up fixing my queue table with the following to avoid the issue in
the future:
ALTER SEQUENCE transfer_transferid_seq MAXVALUE 2147483647 CYCLE;
Thanks,
Woody
----------------------------------------
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919) 387-3550 x813
www.iglass.net