Oh, great! So I'm going to do this:
select setval('sequencename', ( select max(someid) from sometable ) );
Thanx!
Roy.
> -----Original Message-----
> From: Jeff Eckermann [mailto:jeckermann@verio.net]
> Sent: Thursday, September 13, 2001 5:45 PM
> To: roypgsqlgen@xemaps.com
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] maintaining sequences
>
> You can just reset the next-available value with "select setval
> ('sequencename', newvalue);"