Michael Paesold <mpaesold(at)gmx(dot)at> writes:
> Assuming the documentation is correct, this variable is not reported via
> ParameterStatus messages.
That's intentional. There is no reason for an application to need to
know about that variable, because there is no reason for it to change
behavior in consequence. Applications shouldn't be using backslash-quote,
period -- quote-quote is always correct instead.
> This is a problem for the query parsing code inside the JDBC driver
> because it needs to know about the state of this variable so that
> parsing a query in the driver has the same result as in the backend.
I don't see that the JDBC driver needs to know about it either.
Changing the setting only causes an error to be reported (or not) ---
it does not affect the meaning of a string. Also, the default setting
won't affect JDBC because JDBC only uses client_encoding = UTF8. AFAICS
JDBC can assume that backslash-quote is legal and the backend will
reject it if not.
> I therefore ask to add backslash_quote to the hardcoded list of
> variables that are reported via ParameterStatus in 8.2 as well as all
> back-branches that support V3 as well as the backslash_quote variable
> (7.4, 8.0, 8.1, I guess).
If we did do that, you still couldn't rely on knowing the value, because
there are backends in the field that won't tell you about it.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-11-27 00:32:20|
|Subject: Re: [PATCHES] Avg performance for int8/numeric |
|Previous:||From: Peter Eisentraut||Date: 2006-11-26 23:50:24|
|Subject: Re: [CORE] RC1 blocker issues|