How to make sequence skip existing key in table?

From: Raymond Pau <rpau(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to make sequence skip existing key in table?
Date: 2003-02-18 10:01:34
Message-ID: 20030218100134.91784.qmail@web14204.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi List,

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?

Regards,

Raymond Pau

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-02-18 10:04:34 " Adding missing FROM-clause entry for table .... " problem.
Previous Message Dave Gomboc 2003-02-18 08:57:13 select from update from select?