Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3
Date
Msg-id 14596.1311795815@sss.pgh.pa.us
Whole thread Raw
In response to Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: sinval synchronization considered harmful
Next
From: Florian Pflug
Date:
Subject: Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3