Re: Serial Unique question

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Serial Unique question
Date: 2005-08-15 15:41:20
Message-ID: m2acjjw6lb.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Madison Kelly <linux(at)alteeve(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2005-08-15 15:45:18 Re: Postgresql Books: Which one ?
Previous Message Michael Fuhr 2005-08-15 15:27:12 Re: Question about the NAME type used in pg_proc and pg_class