On Fri, May 21, 2010 at 1:27 PM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> wrote: > Hi: > > > > I have a table with many constraints. A user tries to insert a record that > violates many of them. The error message I get back lists the first > violation. How cani I (or can I) get them all? the database stops processing after the first error. the only way to generate a list is to check it on the client first, or do something like make a 'before' trigger to pre-scan. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
