Douglas McNaught wrote:
Madison Kelly <[EMAIL PROTECTED]> writes:
I want to use a 'serial uniue' column in a table but there is
likely to be many, many inserts and deletes from this column. I was
wondering, what happens when the serial value reaches
2,147,483,647'? Does it roll back over to '1' and keep going or
will the database start erroring out? This isn't likely to be a
problem any time soon, but over the course of a year or more it
might be.
Use a "bigserial" instead?
-Doug
Same issue, delaying a potential problem, not addressing it. :)
Madison
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend