Postgres Pro
Downloads
Home   >   mailing lists

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

From Raymond Pau
Subject How to make sequence skip existing key in table?
Date
Msg-id 20030218100134.91784.qmail@web14204.mail.yahoo.com
Whole thread Raw
In response to Re: trigger after with cursor  (Christoph Haller <ch@rodos.fzk.de>)
Responses Re: How to make sequence skip existing key in table?
Re: How to make sequence skip existing key in table?
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: trigger after with cursor
Next
From: Rajesh Kumar Mallah
Date:
Subject: " Adding missing FROM-clause entry for table .... " problem.