Re: Add schema-qualified relnames in constraint error messages. - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Add schema-qualified relnames in constraint error messages.
Date
Msg-id CAKFQuwY6Zg-LKZOTh4zVRoU2SbiCR6DcmSA7nJ6VaCbS4CZaTw@mail.gmail.com
Whole thread Raw
In response to Re: Add schema-qualified relnames in constraint error messages.  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Thu, Feb 11, 2016 at 10:53 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> most recent error in verbose mode, without making a permanent session
> state change.  Something like
>
> regression=# insert into bar values(1);
> ERROR:  insert or update on table "bar" violates foreign key constraint "bar_f1_fkey"
> DETAIL:  Key (f1)=(1) is not present in table "foo".
 
> regression=# \saywhat

​Maybe its too cute but I'll give a +1 for this alone.

David J.
 

pgsql-hackers by date:

Previous
From: Konstantin Knizhnik
Date:
Subject: Clock with Adaptive Replacement
Next
From: Michael Paquier
Date:
Subject: Re: Support for N synchronous standby servers - take 2