Postgres Pro
Downloads
Home   >   mailing lists

Re: How to make sequence skip existing key in table? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: How to make sequence skip existing key in table?
Date
Msg-id 200302180907.21014.josh@agliodbs.com
Whole thread Raw
In response to How to make sequence skip existing key in table?  (Raymond Pau <rpau@yahoo.com>)
Responses Re: How to make sequence skip existing key in table?  (Raymond Pau <rpau@yahoo.com>)
List pgsql-sql
Tree view 
Raymond,

> I am using sequence to generate to a list of unique
> key id that will be used as the primary key for some
> tables.
>
> My question is when the sequence wraps over to the
> minimum value(1), how can I ensure that the next id is
> not in the tables?

Do you really expect more than 2.4 billion rows?

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re:
Next
From: Dave Gomboc
Date:
Subject: select from update from select?