Re: 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: Re: How to make sequence skip existing key in table?
Date: 2003-02-21 06:29:22
Message-ID: 20030221062922.30510.qmail@web14204.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


--- Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> 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?

No, not really.
I guess my worries are groundless after all.

Thanks.
>
> --
> Josh Berkus
> Aglio Database Solutions
> San Francisco

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Samoylov 2003-02-21 08:04:16 Re: How to drop all the sequences
Previous Message ε‘εŽδΈœ 2003-02-21 03:35:40 Fw: