Re: getting details about integrity constraint violation - Mailing list pgsql-sql

From Tom Lane
Subject Re: getting details about integrity constraint violation
Date
Msg-id 14879.1117729929@sss.pgh.pa.us
Whole thread Raw
In response to getting details about integrity constraint violation  (Markus Bertheau <twanger@bluetwanger.de>)
Responses Re: getting details about integrity constraint violation  (PFC <lists@boutiquenumerique.com>)
List pgsql-sql
Markus Bertheau <twanger@bluetwanger.de> writes:
> how would I find out details about for example what constraint was
> violated by an insert statement?

You can't, at the moment, except by parsing the text message.

The "error fields" facility in the FE/BE protocol could be extended
in that direction, and I think there's already been some discussion
about it; but no one has stepped up with a concrete proposal, much
less volunteered to do the work ...
        regards, tom lane


pgsql-sql by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: [GENERAL] index row size 2728 exceeds btree maximum, 27
Next
From: Bruno Wolff III
Date:
Subject: Re: index row size 2728 exceeds btree maximum, 27