Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: getting all constraint violations
Date
Msg-id 21379.1274463384@sss.pgh.pa.us
Whole thread Raw
In response to getting all constraint violations  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: getting all constraint violations
List pgsql-general
Tree view 
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> I have a table with many constraints.  A user tries to insert a record that violates many of them.  The error message
Iget back lists the first violation. How cani I (or can I) get them all? 

You can't, it stops running the command at the first error.

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: getting all constraint violations
Next
From: Francisco Reyes
Date:
Subject: Re: Select max(primary_key) taking a long time