Re: [BUGS] [GENERAL] Should SERIAL column have MAXVAL set on sequence

2007-07-24 Thread Zoltan Boszormenyi
Jim Nasby írta: Moving to -bugs. On Jul 23, 2007, at 9:02 AM, Woody Woodring wrote: 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

Re: [BUGS] [GENERAL] Should SERIAL column have MAXVAL set on sequence

2007-07-24 Thread Tom Lane
Jim Nasby <[EMAIL PROTECTED]> writes: > On Jul 23, 2007, at 9:02 AM, Woody Woodring wrote: >> 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; > This does seem like a bug... I see no

Re: [BUGS] [GENERAL] Should SERIAL column have MAXVAL set on sequence

2007-07-24 Thread Jim Nasby
Moving to -bugs. On Jul 23, 2007, at 9:02 AM, Woody Woodring wrote: 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 pa