Re: serial columns & loads misfeature? - Mailing list pgsql-general

On Fri, 28 Jun 2002 13:28:20 -0500, Kevin Brannen
<kevinb@nurseamerica.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