Resetting a sequence's last value... - Mailing list pgsql-general

From Sean Chittenden
Subject Resetting a sequence's last value...
Date
Msg-id 20030427073645.GK35599@perrin.int.nxad.com
Whole thread Raw
Responses Re: Resetting a sequence's last value...  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-general
I have a database application that makes extensive use of currval(),
but after a certain point in the transaction, I'd like to reset the
state of a given sequence so that the backend will act as if the
sequence hasn't been called.  Something like resetval() or the like is
what I'm looking for, but it doesn't exist as far as I can tell.
Other than reconnecting to the backend, are there other programmatic
alternatives?  -sc

--
Sean Chittenden


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Backing up 16TB of data (was Re: > 16TB worth of
Next
From: Shridhar Daithankar
Date:
Subject: Re: Resetting a sequence's last value...