COPY FROM with a serial not null column

Поиск
Список
Период
Сортировка
От John Taylor
Тема COPY FROM with a serial not null column
Дата
Msg-id 02081616204005.01454@splash.hq.jtresponse.co.uk
обсуждение исходный текст
Ответы Re: COPY FROM with a serial not null column
Список pgsql-novice
Hi,

I'm having trouble using COPY FROM with a table that has a serial NOT NULL column.

If I use psql to INSERT with a NULL value for the appropriate column, everything
works fine, and the next value in the sequence is inserted.

However, if I use COPY table FROM filename, I get an error:
ERROR:  copy: line 1, CopyFrom: Fail to add null value in not null attribute seq

(The column in question is called seq).

Does anyone have ideas how I can get this to work ?


Thanks
JohnT

В списке pgsql-novice по дате отправления: