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

> > 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..

That won't work because it'll return the last value. In this case,
I'm looking to have things return an error if someone calls currval()
on the sequence. -sc

--
Sean Chittenden