| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Petr Korobeinikov <pkorobeinikov(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Add schema-qualified relnames in constraint error messages. |
| Date: | 2016-02-11 21:30:41 |
| Message-ID: | CAKFQuwY6Zg-LKZOTh4zVRoU2SbiCR6DcmSA7nJ6VaCbS4CZaTw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Feb 11, 2016 at 10:53 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-02-11 22:40:54 | Re: Support for N synchronous standby servers - take 2 |
| Previous Message | Konstantin Knizhnik | 2016-02-11 21:02:53 | Clock with Adaptive Replacement |