Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column

On 9/5/19 7:35 AM, Tom Lane wrote:
> Lele Gaifax <lele@metapensiero.it> writes:
>> I'm hitting a problem very similar to the one described here[1]

> 
> pg_restore dumpfile | sed s'/^SELECT pg_catalog.set_config('search_path', '', false);//' | psql targetdb
> 
> There's been some discussion of providing a simpler way to do this,
> but nothing's been done about that either.

My 2 cents would be for a --unsecure-path option to pg_dump/restore that 
would drop the pg_catalog.set_config('search_path', '', false).

> 			regards, tom lane
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com