[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Inserting geometries using a
From:       Guido Lemoine <guido.lemoine () jrc ! it>
Date:       2006-07-25 15:23:51
Message-ID: 44C63787.2030707 () jrc ! it
[Download RAW message or body]

So, did you remove the single ' quotes? I had to revise the code that used
an old JDBC driver (requiring the ' quote) to the new 8.x driver where the
use of the quote causes an error. Obviously a JDBC driver problem then.
On the "back-end" you still need the quote, i.e. when using psql. It's nice
that the new driver takes care of the quotes, but not really consistent. I
would expect the SQL statements in my Java code to be more or less the
same as in psql.

GL

Yeroc wrote:

>Markus,
>
>I tried it with both the jdbc driver I had been using previously as well as
>the new one bundled with v8.1.4.  There was no difference in behavior
>between the two drivers.  The difference appears to be in the backend.  
>
>The code is identical.  I took my existing code and just re-ran it against
>the new database.  As you say, now that I think about it, it's a wonder that
>it ever worked.  There must have been a bug (or feature? ;) in the backend
>that caused it to work before.
>
>Thanks for your reply.
>Corey
>
>
>  
>

[prev in list] [next in list] [prev in thread] [next in thread]