8.2 and nonstandard use of \\ in prepared statements

From: "Stefano B(dot)" <stefano(dot)bonnin(at)comai(dot)to>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: 8.2 and nonstandard use of \\ in prepared statements
Date: 2006-12-15 08:02:38
Message-ID: 03a101c7201f$6396a300$0501a8c0@comai04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I have installed postgresql 8.2 and I get some warning messages about use of backslashes in my queries.

I have a query like:

insert into mytable (f1,f2,f3) values (?,?,?)

where f3 is a binary stream

when the query is executed the server returns a warning about the use of backslashes in the query:

postgresWARNING: nonstandard use of \\ in a string literal at character 96
2006-12-15 08:17:17 CET [local] dms postgresHINT: Use the escape string syntax for backslashes, e.g., E'\\'.
2006-12-15 08:17:17 CET [local] dms postgresLOG: statement: insert into synch_list (s_name,s_client,s_data) values ('20061215083000_cast,'casteggio','PK\\003\\004\\024\\000\\010\\000\\010\\000\\315C\\2175\\000\\000\\000\\...................')

I have tryed to use the new escape sintax:

insert into mytable (f1,f2,f3) values (?,?,(E?))

but it seems that the jdbc driver doesn't care about my new query and sends the query without the new escape syntax.

Is it possible to escape binary streams with the new escape sintax?
Thanks in advance.
Stefano

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Madhu Babu 2006-12-15 19:03:34 Re: UNSUBSCRIBE
Previous Message Ken Johanson 2006-12-14 15:38:26 Re: Synthesize support for Statement.getGeneratedKeys()?