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 <bo...@ejurka.com> wrote: > From: Kris Jurka <bo...@ejurka.com> > Subject: Re: [BUGS] Possible bug with BYTEA and JDBC > To: "Gregory Kotsaftis" <gregkotsaf...@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 > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs