Re: getting all constraint violations - Mailing list pgsql-general

From Merlin Moncure
Subject Re: getting all constraint violations
Date
Msg-id AANLkTin9bOvfwC2_IpufMk6z7mewOlll_4yomcYQpHaC@mail.gmail.com
Whole thread Raw
In response to getting all constraint violations  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On Fri, May 21, 2010 at 1:27 PM, Gauthier, Dave <dave.gauthier@intel.com> 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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: getting all constraint violations
Next
From: Tom Lane
Date:
Subject: Re: getting all constraint violations