Re: [BUGS] COPY and sequences

2003-11-10 Thread Neil Conway
"Przemysław" <[EMAIL PROTECTED]> writes: > 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. Doesn't sound like a bug. If the input data for COPY does not include PK values, you should not includ

[BUGS] COPY and sequences

2003-11-08 Thread Przemysław
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',(

[BUGS] COPY and sequences

2003-11-08 Thread todhunter
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'