Обсуждение: COPY and sequences

Поиск
Список
Период
Сортировка

COPY and sequences

От
"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',(select
max(idkre) from kom_kontrahenciref),true);
and that's all
Thank's for listening :-)


Re: COPY and sequences

От
Neil Conway
Дата:
"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