getting all constraint violations

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: getting all constraint violations
Date: 2010-05-21 17:27:47
Message-ID: 482E80323A35A54498B8B70FF2B879800458B88674@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

I'm running 8.3.4 on linux, running through perl/DBI, getting the error message from $dbh->errstr.

Thanks in Advance for any help :-)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2010-05-21 17:35:25 Re: getting all constraint violations
Previous Message erobles 2010-05-21 17:00:24 cleaning wal files from postgres