Re: log bind parameter values on error - Mailing list pgsql-hackers

From Andres Freund
Subject Re: log bind parameter values on error
Date
Msg-id 20191205180325.2jscsekp34zzpvms@alap3.anarazel.de
Whole thread Raw
In response to Re: log bind parameter values on error  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: log bind parameter values on error  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Hi,

On 2019-12-05 14:19:45 -0300, Alvaro Herrera wrote:
> What this does is set an error callback, which adds the parameter values
> in the DETAIL line.  This is at odds with all existing error callbacks:
> they only add stuff to the CONTEXT string.  The implication is that
> if an error site has a direct errdetail_log() and is run under this
> error stack, that site's detail is going to be lost and replaced by the
> "params" one.  Currently there aren't many errdetail_log() lines, so it
> doesn't seem like a terrible problem.  However, it's something to keep
> in mind.

It'd not be too hard avoiding overwriting if we wanted. Makes me wonder
though, if we ought to invent something similar to the errdata fields we
have for schema, table, etc...

Haven't yet had time to catch up to the discussion in this thread of the
last two weeks...

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Using multiple extended statistics for estimates
Next
From: Bruce Momjian
Date:
Subject: Re: Append with naive multiplexing of FDWs