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(at)verio(dot)net]
> Sent: Thursday, September 13, 2001 5:45 PM
> To: roypgsqlgen(at)xemaps(dot)com
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] maintaining sequences
>
> You can just reset the next-available value with "select setval
> ('sequencename', newvalue);"