From: Rolland Crunk <rc@aenet.net>
To: pgsql-interfaces@hub.org
Subject: [INTERFACES] JDBC escape problem
Date: Thu, 08 Jul 1999 00:56:51 -0700
Message-ID: <4.1.19990708001241.00bfa6b0@crunk.net> (raw)
I'm encountering a problem with the implementation of escapes using
the 6.5 JDBC driver. If I attempt to insert a timestamp value using
the following syntax, I get an error from the postgreSQL parser complaining
about the '{' character:
stmt.executeUpdate("insert into tstest values ( { ts '1999-07-07 00:00:00' } )");
However, the following statement works:
stmt.executeUpdate("insert into tstest values ( '{ ts 1999-07-07 00:00:00 }' )");
Unfortunately, the former is the correct syntax where the second isn't.
From what I could determine tracing the code, there is no escape processing
performed in the PostgreSQL jdbc driver, and the error is originating from the
database backend.
I thought it unusual that I didn't see reference to this problem in the mail
archives (though I admit I only went back a few months). Is this a known
problem?
What are the consequences of fixing it in the back-end? Will it break other
drivers that depend on this syntax?
Any advise would be appreciated.
Thanks in advance,
rc
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rc@aenet.net, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] JDBC escape problem
In-Reply-To: <4.1.19990708001241.00bfa6b0@crunk.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox