On Thu, Feb 11, 2016 at 9:50 AM, Robert Haas <robertmh...@gmail.com> wrote: >> Actually, what'd be really handy IMO is something to regurgitate the >> 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 >> ERROR: 23503: insert or update on table "bar" violates foreign key >> constraint "bar_f1_fkey" >> DETAIL: Key (f1)=(1) is not present in table "foo". >> SCHEMA NAME: public >> TABLE NAME: bar >> CONSTRAINT NAME: bar_f1_fkey >> LOCATION: ri_ReportViolation, ri_triggers.c:3326 >> regression=# > > Wow, that's a fabulous idea. I see Oleksandr has tried to implement > it, although I haven't looked at the patch. But I think this would be > REALLY helpful.
+1 -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
