Re: getting details about integrity constraint violation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: getting details about integrity constraint violation
Date: 2005-06-02 16:32:09
Message-ID: 14879.1117729929@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Markus Bertheau <twanger(at)bluetwanger(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-02 16:35:42 Re: [SQL] index row size 2728 exceeds btree maximum, 27
Previous Message Jaime Casanova 2005-06-02 15:48:21 Re: [SQL] index row size 2728 exceeds btree maximum, 27