Re: setting currval in a sequence without recreating the sequence
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 10 Jul 2008 13:47:38 -0800
Message-ID: <4876756a$1@news.victoria.tc.ca>
Date: 10 Jul 2008 13:47:38 -0800
Message-ID: <4876756a$1@news.victoria.tc.ca>
seannakasone (snakason_at_pgsnakason.hawaiianelectric.net) wrote:
: Can you set the currval in a sequence without having to drop and recreate
: the sequence? I rather not have to drop and recreate something because I
: have to do a lot more paperwork. Can't we just use alter or update?
: please provide example.
Loop over nextval until you get to the number you want (assuming you want a higher number). Received on Thu Jul 10 2008 - 16:47:38 CDT