Re: Possible bug with BYTEA and JDBC

Kris you are without a doubt a life saver!
Being new to blobs altogether, this issue gave me a really hard time for more than a week! Thanks for the possible solutions (I will probably go with 2 or 1).
Thank you very much (and I REALLY mean it!)
Greg :)

--- On Sun, 2/14/10, Kris Jurka <books(at)ejurka(dot)com> wrote:

> From: Kris Jurka <books(at)ejurka(dot)com>
> Subject: Re: [BUGS] Possible bug with BYTEA and JDBC
> To: "Gregory Kotsaftis" <gregkotsaftis(at)yahoo(dot)com>
> Cc: pgsql-bugs(at)postgresql(dot)org
> Date: Sunday, February 14, 2010, 4:42 PM
>
>
> 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
>