COPY and sequences

Поиск
Список
Период
Сортировка
От Przemysław
Тема COPY and sequences
Дата
Msg-id web-248384@coig.katowice.pl
обсуждение исходный текст
Ответы Re: COPY and sequences
Список 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 по дате отправления: