Re: Resetting a sequence's last value...

On Sunday 27 April 2003 13:06, Sean Chittenden wrote:
> 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

Umm.. setval doesn't work?

file:/usr/local/doc/postgresql/html/functions-sequence.html is where I looked
at my local 7.3.2 installation..

 Shridhar