Re: [BUGS] missing foreign key fails silently using COPY

2002-02-27 Thread Tom Lane
I wrote: > [ In psql, COPY from stdin fails to report referential integrity errors ] > After further investigation I'm still unsure where to pin the blame. > What the backend is actually sending back is > C COPY -- completion tag for COPY > E errmsg-- error detected

Re: [BUGS] missing foreign key fails silently using COPY

2002-02-25 Thread Tom Lane
I wrote: > [EMAIL PROTECTED] (Lee Harr) writes: >> When COPYing data to a table which uses foreign keys, if there >> is a reference to a key which is not there, the copy fails >> (as expected) but there is no error message. >> Hmm. Looking at it more, seems like there is an error message >> when

Re: [BUGS] missing foreign key fails silently using COPY

2002-02-25 Thread Tom Lane
[EMAIL PROTECTED] (Lee Harr) writes: > When COPYing data to a table which uses foreign keys, if there > is a reference to a key which is not there, the copy fails > (as expected) but there is no error message. > Hmm. Looking at it more, seems like there is an error message > when using: > COPY "f

[BUGS] missing foreign key fails silently using COPY

2002-02-25 Thread Lee Harr
When COPYing data to a table which uses foreign keys, if there is a reference to a key which is not there, the copy fails (as expected) but there is no error message. Hmm. Looking at it more, seems like there is an error message when using: COPY "f" FROM '/home/lee/f.dat'; but _not_ when using: