Postgres Pro
Downloads
Home   >   mailing lists

Re: resetting serials and sequences - Mailing list pgsql-sql

From Tom Lane
Subject Re: resetting serials and sequences
Date
Msg-id 27714.978386476@sss.pgh.pa.us
Whole thread Raw
In response to resetting serials and sequences  (Ferruccio Zamuner <nonsolosoft@diff.org>)
List pgsql-sql
Tree view 
Ferruccio Zamuner <nonsolosoft@diff.org> writes:
> Is this a bug?         

No, but it is a missing feature: there's no way to reset a sequence's
is_called flag once it's been set.  This is fixed for 7.1: there's now
a three-parameter variant of setval() to let you do exactly that.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Updating two table via a Rule?
Next
From: Michael Davis
Date:
Subject: Removing a constraint?