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