Re: [SQL] resetting serials and sequences

2001-01-01 Thread Tom Lane
Ferruccio Zamuner <[EMAIL PROTECTED]> 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.

[SQL] resetting serials and sequences

2001-01-01 Thread Ferruccio Zamuner
Hi, #create temp table a ( id serial primary key, name text not null); #insert into a (name) values ('Tom'); #insert into a (name) values ('Fer'); #insert into a (name) values ('Mario'); #select * from a; id | name +--- 1 | Tom 2 | Fer 3 | Mario (3 rows) OK. Now