bytea problems

From: Lars Gustafsson <gumse(at)me(dot)com>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: bytea problems
Date: 2019-05-24 09:10:27
Message-ID: 382E37EB-BEF7-4F98-8329-2EE57AD35367@me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have an old Java-app that was developed a long time ago, it was written for Postgres version 8.

I have exported the DB from that old server and imported into a Postgres11 server.

Almost everything seems to work. Except when my app tries to fetch jpeg files stored in the DB as bytea.
The files I retrieve are unreadable. But when I look att the pictures in Postico they look good & I can save them and open them with other applications.

I can add new pictures to the DB using the old app, they also works in Postico, but not when my app tries to read them back.

Any hints? Have the way bytea data is selected changed? Should I try to select with some kind of decode function?

Regards,
Lars.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2019-05-24 09:51:28 Re: bytea problems
Previous Message Vianello, Daniel A 2019-05-22 15:09:07 RE: SQL help?