From: | Madison Kelly <linux(at)alteeve(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Serial Unique question |
Date: | 2005-08-15 15:07:31 |
Message-ID: | 4300AFB3.5060100@alteeve.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
This might seem like an odd question but I couldn't find the answer
in the docs (did I miss the obvious?).
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.
I suppose one answer is to periodically drop and recreat the table
(no long-term important data will be in there. Data will last usually
less that 1sec before being deleted).
Thanks all!
Madison
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Sydney-Smith | 2005-08-15 15:13:32 | Re: Authenticating using Windows XP login |
Previous Message | Tony Caduto | 2005-08-15 15:02:01 | Question about the NAME type used in pg_proc and pg_class |