Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] [PATCH] Use $ parameters as replacement characters forpg_stat_statements - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] [PATCH] Use $ parameters as replacement characters forpg_stat_statements
Date
Msg-id a6538083-854a-9739-769d-3ada5de496dc@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] [PATCH] Use $ parameters as replacement characters for pg_stat_statements  (Lukas Fittl <lukas@fittl.com>)
Responses Re: [HACKERS] [PATCH] Use $ parameters as replacement characters for pg_stat_statements  (Lukas Fittl <lukas@fittl.com>)
Re: [HACKERS] [PATCH] Use $ parameters as replacement characters for pg_stat_statements  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
On 2/28/17 20:01, Lukas Fittl wrote:
> Currently pg_stat_statements replaces constant values with ? characters.
> I've seen this be a problem on multiple occasions, in particular since
> it conflicts with the use of ? as an operator.
> 
> I'd like to propose changing the replacement character from ? to instead
> be a parameter (like $1).

Hmm, I think this could confuse people into thinking that the queries
displayed were in fact prepared queries.

Maybe we could gather some more ideas.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] objsubid vs subobjid
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Possible spelling fixes