Re: How to get schema name which violates fk constraint

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get schema name which violates fk constraint
Date: 2008-10-22 13:58:06
Message-ID: 760EC27241A6495F87DC92FC1B9685BF@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> The type of fix I'd like to see would be to not change message texts at
> all, but to add separate error-message fields for the name and schema
> name of object(s) involved in an error; which would be details that
> psql, for example, would show only in VERBOSE mode. Note that error
> report fields along this line are actually required by the SQL spec
> (cf GET DIAGNOSTICS) but we've never got round to implementing 'em.

How about adding also a way to get primary key value(s) of the row which
causes error ?

Andrus.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-10-22 14:16:45 Re: Shopping cart
Previous Message Tom Lane 2008-10-22 13:50:21 Re: How to get schema name which violates fk constraint