On Thu, 20 Jun 2002 pgsql-bugs@postgresql.org wrote:
> Dan Brown (dbrown@pingtel.com) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> can't store {digits} using JDBC
>
> Long Description We are using the JDBC driver, and are losing partial
> data. Whenever we try to store {digits} (note: exactly as shown with
> the curly brackets) we are finding that postgres is storing it as "
> igits ". We can insert it via psql correctly, but not via the JDBC
> driver. Also note, if we store something like {vdigits}, we have no
> problem. Also, it works fine in Oracle 8.
This is an escape syntax. {d refers to a date, which is why you are seeing
igits not {digits}.
Try the Statement.setEscapeProcessing() method to turn it off.
Peter
>
> The version of postgreSQL we are using is:
> PostgreSQL 7.2.1 on i686-pc-cygwin, compiled by GCC 2.95.3-5
> ( we are also seeing the same problem in Linux ).
>
> Sample Code
>
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Peter T Mount
peter@retep.org.uk
http://www.retep.org.uk
