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@ejurka.com> wrote:
> From: Kris Jurka <books@ejurka.com>
> Subject: Re: [BUGS] Possible bug with BYTEA and JDBC
> To: "Gregory Kotsaftis" <gregkotsaftis@yahoo.com>
> Cc: pgsql-bugs@postgresql.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
>
