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 ?
pgsql-novice by date
|Next:||From: Oliver Elphick||Date: 2002-08-16 16:19:11|
|Subject: Re: COPY FROM with a serial not null column|
|Previous:||From: Tom Lane||Date: 2002-08-16 14:11:46|
|Subject: Re: Is my database done for? |