COPY and sequences - Mailing list pgsql-bugs

From Przemysław
Subject COPY and sequences
Date
Msg-id web-248384@coig.katowice.pl
Whole thread Raw
Responses Re: COPY and sequences  (Neil Conway <neilc@samurai.com>)
List pgsql-bugs
Hello
I dont know is this a bug but when I use COPY to load data
into table sequence of the primary key in this table have
always start value = 1. But in the table is about 13000
rows :-). I wrote script like this to coorect this
sequence
select
setval('public.kom_kontrahenciref_idkre_seq',(select
max(idkre) from kom_kontrahenciref),true);
and that's all
Thank's for listening :-)


pgsql-bugs by date:

Previous
From: Reece Hart
Date:
Subject: pg_dump function dumped after required for table definition
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.4RC1 crashes on Panther