Re: COPY seems to work, but no data in the table

In article <20020716162506(dot)GB27614(at)klamath(dot)dyndns(dot)org>, Neil Conway wrote:
> On Mon, Jul 15, 2002 at 07:36:58PM -0700, Brian Dougherty wrote:
>> I executed a successful COPY, or at least psql responded "COPY", but
>> when I looked at the table with SELECT *, no rows were found.
>>
>> What's going on there?
>
> Can you give us a full example? For instance, the definition of the
> table, the command you're using to COPY in data, and a sample of
> the source data.
>

I have run in to the exact same problem (check in the archives...
"missing foreign key fails silently using COPY")

oh. Here is is:

http://archives.postgresql.org/pgsql-bugs/2002-02/msg00173.php

(you can view source if the page appears blank...)

What I found was that if a foreign key constraint was not satisfied
while COPYing data in to a table, the whole COPY would fail, but
there was never any error message.

As I recall it, Tom Lane looked at this problem at the time and said
that it would be less than simple to fix.