Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group