Serial Unique question

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

Responses

Browse pgsql-general by date

  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