Byte Escape Syntax - Mailing list pgsql-general

From Howard Yeh
Subject Byte Escape Syntax
Date
Msg-id t2gab5a379d1004151030pf115817dxb2cd90c6365ed211@mail.gmail.com
Whole thread Raw
Responses Re: Byte Escape Syntax  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Is Postgres's byte escape syntax something that could be set by the client?

I am running into a strange problem when I access postgres try two
different Ruby ORM's. I am guessing that one of them is doing
something funny to the client connections.

Looking at the Ruby C-driver, it's calling PQescapeBytea rather then
PQescapeByteaConn. And tracing PQescapeBytea, sometimes it escapes '\'
as '\\', as describe in the manual, sometimes it doesn't do that
escape. But it always escape the single quote character ' . All the
connections are using UTF-8 encoding.

I wrote my own byte escaping function in Ruby, which does escaping
according to the 8.4 manual, but again it works for some connections,
but not others.

Howard

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: solaris tarballs and pl/java
Next
From: Tom Lane
Date:
Subject: Re: Byte Escape Syntax