"Gauthier, Dave" <dave.gauth...@intel.com> writes:
> Is there a way to temporarily suspend constraint checking for a particular
> constraint inside of the transaction, try the insert again, capture the next
> violation, then the next, etc... then rollback after all have been collected?
You could do something like
BEGIN;
ALTER TABLE DROP CONSTRAINT ...
INSERT ...
ROLLBACK;
The major deficiency of this is that the ALTER TABLE would grab
exclusive lock on the table, so this doesn't scale if you need to
have several insertions happening in parallel.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
