Re: Zeroing single tuple in data file.

A few more information requests if you don't mind.

Can you analyze the table ie "ANALYZE USERS" without error?

Could you please paste the output from "\d+ users".

And try SELECT COUNT(*) FROM users WHERE id_usr IS NULL;

Is your database large? Can you shut down the instance cleanly and take a
backup of it before making any further changes?

Could you also copy the mailing list into your reply please to ensure others
can see and possibly assist?

On Sun, Nov 21, 2010 at 7:27 PM, Lukasz Brodziak
<lukasz(dot)brodziak(at)gmail(dot)com>wrote:

> An example statement: COPY users
> And the error: COPY failed: ERROR: null value in column "id_usr"
> violates not-null constraint
>