I am trying to work out why PostgreSQL responds with "Successfully copied."
when I think the copy has failed.
I am testing a table with a FOREIGN KEY constraint which is working (yay!).
Although invalid data is not loading, PostgreSQL responds with a message
that looks as though it was successful.
test=> \copy assays from assay_test3.txt;
The number of rows in the table remains the same as before the copy.
"assay_test3.txt" contains a single row with data not meeting the foreign
Is there perhaps an "errorlevel" switch that needs to be turned up a bit?
I will post the table structure and load file if necessary.
pgsql-sql by date
|Next:||From: Guus||Date: 2000-03-09 12:46:12|
|Previous:||From: Mathijs Brands||Date: 2000-03-09 01:04:09|
|Subject: Re: [SQL] postgreSQL vs mySQL|