Thread: COPY and sequences
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 :-)
"Przemys=B3aw" <przemyslaw.slupkowski@euro.coig.pl> 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 =3D > 1. Doesn't sound like a bug. If the input data for COPY does not include PK values, you should not include the PK column in the COPY's column list, and make sure the PK column's default value gets the nextval() from the sequence. -Neil