Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Petro Meier <petro85(at)gmx(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3
Date: 2011-07-27 19:43:35
Message-ID: 14596.1311795815@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Excerpts from Petro Meier's message of mi jul 27 02:51:22 -0400 2011:
>> If I use PQescapeByteaConn() for a conenction to a PG9.1 Beta3 server,
>> this function returns (e.g.) "\xea2abd8ef31...(and so on.)...".
>>
>> Here the problem: there should be a second backslash in the prefix.

> You're just being bitten by the fact that the
> standard_conforming_strings setting changed its default from false to
> true.

Well, the question is why is it actually failing for him. AFAICS the
value being emitted is correct for the 9.1 server. Perhaps we need to
see a complete example...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Pflug 2011-07-27 19:44:06 Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3
Previous Message Phil Sorber 2011-07-27 19:21:42 patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c