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

From Bruno Wolff III
Subject Re: Resetting a sequence's last value...
Date
Msg-id 20030427205216.GA28917@wolff.to
Whole thread Raw
In response to Re: Resetting a sequence's last value...  (Sean Chittenden <sean@chittenden.org>)
Responses Re: Resetting a sequence's last value...  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Resetting a sequence's last value...  (Sean Chittenden <sean@chittenden.org>)
List pgsql-general
On Sun, Apr 27, 2003 at 12:39:37 -0700,
  Sean Chittenden <sean@chittenden.org> wrote:
>
> Thoughts?  I got a post offlist suggesting writing a C function, but
> that's pretty dependent on the backend and would have to be recompiled
> from version to version, something I'm not too wild about.  -sc

What would seem logical to me is using the iscalled parameter to setval
to determine this. If you call setval('seq', 1, false), I think it
would be reasonable for the currval('seq') to be undefined until
nextval('seq') or setval with iscalled=true is called.


pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Resetting a sequence's last value...
Next
From: Tom Lane
Date:
Subject: Re: Resetting a sequence's last value...