Postgres Pro
Downloads
Home   >   mailing lists

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

From Andres Freund
Subject Re: [HACKERS] [PATCH] Use $ parameters as replacement characters forpg_stat_statements
Date
Msg-id 20170304184605.kbspuoqmr4pnyrvs@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] [PATCH] Use $ parameters as replacement characters for pg_stat_statements  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Hi,

On 2017-03-04 11:02:14 -0500, Tom Lane wrote:
> But speaking of ambiguity: isn't it possible for $n symbols to appear in
> pg_stat_statements already?

Indeed.

> I think it is, both from extended-protocol
> client queries and from SPI commands, which would mean that the proposal
> as it stands is not fixing the ambiguity problem at all.  So yes, we need
> another idea.

I think using $ to signal a parameter is still a good idea, as people
kinda have to know that one anyway.  Maybe one of "$:n" "$-n"?

- Andres

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [HACKERS] PATCH: pageinspect / add page_checksum andbt_page_items(bytea)
Next
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] [PATCH] Use $ parameters as replacement characters for pg_stat_statements