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  (Oliver Elphick <olly@lfix.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Is my database done for?
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: COPY FROM with a serial not null column