On Fri, Feb 8, 2019 at 1:58 AM Tom Lane <t...@sss.pgh.pa.us> wrote:
> I wrote:
> >> This looks like a pgadmin bug ...
>
> > Looking at it, I'm betting somebody thought this was a cute way to
> > set bytea_output if it exists, without getting a failure on servers
> > too old to have it. We added that in 9.0, so maybe it's not quite
> > old enough to make it a moot point; but failing on RO servers is
> > not nice either. Anyway, yeah, it's pgadmin's problem to fix.
>
> Better idea:
>
> select set_config('bytea_output','escape',false) from pg_settings where
> name = 'bytea_output';
>
Thanks for the solution - Tom.
We will fix that in that in pgAdmin.
-- Thanks, Ashesh
>
> This is depressingly lacking in safe schema-qualification, btw.
>
> regards, tom lane
>
>
