Re: Possible bug with BYTEA and JDBC - Mailing list pgsql-bugs

From Kris Jurka
Subject Re: Possible bug with BYTEA and JDBC
Date
Msg-id alpine.BSO.2.00.1002140930110.28652@leary.csoft.net
Whole thread Raw
In response to Possible bug with BYTEA and JDBC  (Gregory Kotsaftis <gregkotsaftis@yahoo.com>)
Responses Re: Possible bug with BYTEA and JDBC  (Gregory Kotsaftis <gregkotsaftis@yahoo.com>)
List pgsql-bugs
On Sat, 13 Feb 2010, Gregory Kotsaftis wrote:

> postgresql-8.4-701.jdbc4.jar
> postgresql-8.5alpha3
>
> I followed the steps in the blob tutorial and tried to test the BYTEA
> example:

The 8.5/9.0 release has changed the default bytea output format and the
8.4 JDBC driver does not support it.  You've got a couple of options:

1) Change the bytea format back to the 8.4 supported format.  Set
bytea_output = escape in your postgresql.conf.

2) Build the JDBC driver from CVS which does support the new format.

3) Use an 8.4 server.

Kris Jurka

pgsql-bugs by date:

Previous
From: Gregory Kotsaftis
Date:
Subject: Possible bug with BYTEA and JDBC
Next
From: "IP"
Date:
Subject: Re: BUG #5318: Inconsistent PHP pg_result_error_field PGSQL_DIAG_SOURCE_FUNCTION across instalations