Re: Mention column name in error messages
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Franck Verrot <franck@verrot.fr>
Cc: Michael Paquier <michael.paquier@gmail.com>,
Kuntal Ghosh <kuntalghosh.2007@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2016-11-06T21:13:23Z
Lists: pgsql-hackers
Franck Verrot <franck@verrot.fr> writes: > On Sat, Nov 5, 2016 at 11:13 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote: >> The cases that are successfully annotated by the current patch seem to >> mostly already have error cursor information, which really is good enough >> IMO --- you can certainly figure out which column corresponds to the >> textual spot that the cursor is pointing at. > The original intent of that patch tried to cover the case where we insert > records > made of dozens columns sharing the same type definition, and trying to > understand > what is going on, at a glance, when we debugged something like this: > ... > Relying on the cursor seems to be of little help I'm afraid. Well, it would be an improvement over what we've got now. Also, a feature similar to what I suggested would help in localizing many types of errors that have nothing to do with coercion to a target column type. regards, tom lane
Commits
-
Improve logging of bad parameter values in BIND messages.
- 1ea396362be1 14.0 landed