pgsql ODBC text escaping issue

From: Zhidong She <zhidong(dot)she(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, Zhidong She <zhidong(dot)she(at)gmail(dot)com>
Subject: pgsql ODBC text escaping issue
Date: 2011-07-20 07:58:16
Message-ID: CAAhmQAc2366SSfDmkihFJXzqSE5TvkSF2f-J-00d3V_JydttfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-odbc

Hi all,

I have a problem on text escaping. In my application, I have a table
offlinemsg, which has one column id with long, and has another column
msg with text.
pgsql ODBC and dynamic SQL binding was used when I tried to insert
data into offlinemsg.
the sql is : insert into offlinemsg values(?, ?)
and the msg value is: <msg='test', from='ss' to='dd'/>

During test, I found that ODBC will automatically add escaping to the
value, so the msg value will be tranfer to: <msg=\\'test\\',
from=\\'ss\\' to=\\'dd\\'/>, then final sent to postgres server.
Becuase this escaping transition is not standard, the postgres server
will log a warning in the pg_log, which is:
2011-07-17 16:53:24 CST WARNING: nonstandard use of \' in a string
literal at character 82
2011-07-17 16:53:24 CST HINT: Use '' to write quotes in strings, or
use the escape string syntax (E'...').

Since we have massive this kind of offline message, after several
days, the disk is full of pg_log and postgres services down.

The ODBC version we used is 07.03.0100.

Is it a known issue? How to avoid the massive warning log?

Thanks very much!

Br,
Zhidong

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2011-07-20 08:41:10 Re: Building an home computer for best Poker Tracker performance
Previous Message John R Pierce 2011-07-20 06:21:31 Re: spacewalk and postgres

Browse pgsql-odbc by date

  From Date Subject
Next Message Raiford 2011-07-20 12:07:51 Re: [ODBC] pgsql ODBC text escaping issue
Previous Message BGoebel 2011-07-18 10:49:56 Re: SQLDescribeCol – schema cache not being updated completely?