On Fri, 28 Jun 2002 13:28:20 -0500, Kevin Brannen
<kevinb(at)nurseamerica(dot)net> wrote:
>create table test (s serial, i int);
>insert into test values (1,1);
>insert into test values (2,2);
>insert into test values (3,3);
>insert into test (i) values (4);
>ERROR: Cannot insert a duplicate key into unique index test_s_key
Kevin,
SELECT setval('test_s_seq', 3);
should do what you need.
Servus
Manfred