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:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 5:45 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] maintaining sequences
>
> You can just reset the next-available value with "select setval
> ('sequencename', newvalue);"
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
