Adam B wrote: > Hello all, > > Is it possible to prevent Postgre from aborting the transaction upon a > constraint violation? Not without use of savepoints. What I like to do is bulk-insert the suspect data into a temp table without constraints, then INSERT INTO ... SELECT it into the target table with appropriate WHERE constraints to prevent attempts to insert invalid values. Another alternative is to constrain each INSERT statement with an appropriate WHERE clause after rephrasing it in INSERT INTO ... SELECT form . -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
