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

--- Josh Berkus <josh@agliodbs.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/