Re: Mention column name in error messages - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Mention column name in error messages
Date
Msg-id 1299.1478466803@sss.pgh.pa.us
Whole thread Raw
In response to Re: Mention column name in error messages  (Franck Verrot <franck@verrot.fr>)
Responses Re: Mention column name in error messages
List 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



pgsql-hackers by date:

Previous
From: Franck Verrot
Date:
Subject: Re: Mention column name in error messages
Next
From: Shay Rojansky
Date:
Subject: Re: macaddr 64 bit (EUI-64) datatype support