Message-Id: <4.1.19990708001241.00bfa6b0@crunk.net>
Date: Thu, 08 Jul 1999 00:56:51 -0700
To: pgsql-interfaces@hub.org
From: Rolland Crunk <rc@aenet.net>
Subject: [INTERFACES] JDBC escape problem
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"


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