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

From Markus Bertheau ☭
Subject Re: getting details about integrity constraint violation
Date
Msg-id 1117789228.9816.2.camel@dicaprio.akademie1.de
Whole thread Raw
In response to Re: getting details about integrity constraint violation  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List pgsql-sql
В Птн, 03/06/2005 в 10:00 +0200, KÖPFERL Robert пишет:
> |
> |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
> 
> 
> So there must be at least a bunnch of error codes (which could be printed in
> addition)?

There are, but they only say something along the lines of "unique
constraint violated", they don't say which one.

Markus

-- 
Markus Bertheau ☭ <twanger@bluetwanger.de>



pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Re: getting details about integrity constraint violation
Next
From: Markus Bertheau ☭
Date:
Subject: 'true'::TEXT::BOOLEAN