Is there a way to more explicitly define where a Referential Integrity
error occurs in a COPY (bulk load) command?
If the error is about a duplicate key value, then COPY gives me the
exact line number.
However, if there is an error due to RI, then a general statement is
issued, and I'm forced to look through
a 9,000 line table for the FK value that doesn't occur in the main table.
Running 7.1.3...and have no intention for the moment of upgrading, this
version is rock solid for me.
Any ideas?
TIA
_________________________
Herb Blacker
Database Administrator
ReCare, Inc.
(512) 791-4340
herbblacker@isgenesis.com