BUG #15569: decode function is not correclty working in 10.6

Started by PG Bug reporting formover 7 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 15569
Logged by: Bindu Harikrishnan
Email address: binduharikrishnanv@gmail.com
PostgreSQL version: 10.6
Operating system: Ubuntu
Description:

Sir
I was using postgres 9.4 version. Currenly I chnaged to version 10.6. I
stored image as bytea datatype . For this purpose I used
decode('','base64') while insert an image into a table. This code is
working in version 9.4. But when I used the same function in version 10.6 it
return different result. Kindly please help me to over come this issue

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: BUG #15569: decode function is not correclty working in 10.6

=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:

I was using postgres 9.4 version. Currenly I chnaged to version 10.6. I
stored image as bytea datatype . For this purpose I used
decode('','base64') while insert an image into a table. This code is
working in version 9.4. But when I used the same function in version 10.6 it
return different result. Kindly please help me to over come this issue

You're not likely to get useful help without being a lot more specific.
In a quick test I don't see any difference in the behavior of decode()
since 9.4, so please show a concrete case where it behaves differently.

One possibility is that it's actually giving the same bytea output,
but it looks different because you have bytea_output set differently
in the two installations.

regards, tom lane