| From: | Lars Gustafsson <gumse(at)me(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: bytea problems |
| Date: | 2019-05-24 10:36:41 |
| Message-ID: | 20052EBA-3A72-4189-9E5D-0429974BEEE3@me.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
HA!! It works!! Fantastic!!
Thank you sooo much, you literally saved my day AND my weekend.
Vielen dank,
Lars.
> 24 maj 2019 kl. 11:51 skrev Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>:
>
>
>
> Am 24.05.19 um 11:10 schrieb Lars Gustafsson:
>> Any hints? Have the way bytea data is selected changed? Should I try to select with some kind of decode function?
>
> yeah, see bytea_output. Wild guess: it is set to 'hex'. Set it back to 'escape'.
> The default bytea output format has changed in 9.x, some years ago.
>
>
> Regards, Andreas
>
> --
> 2ndQuadrant - The PostgreSQL Support Company.
> www.2ndQuadrant.com
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Lund Askøe | 2019-06-06 15:30:31 | Transaction locks on first insert into partitioned table partition |
| Previous Message | Andreas Kretschmer | 2019-05-24 09:51:28 | Re: bytea problems |