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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      15569
Logged by:          Bindu Harikrishnan
Email address:      [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

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

Tom Lane-2
=?utf-8?q?PG_Bug_reporting_form?= <[hidden email]> 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