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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lele Gaifax <lele(at)metapensiero(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column
Date: 2019-09-05 14:50:54
Message-ID: ac4e8909-e85d-42cc-cd32-291561c951ee@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/5/19 7:35 AM, Tom Lane wrote:
> Lele Gaifax <lele(at)metapensiero(dot)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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lu, Dan 2019-09-05 15:04:57 postgresql: Help with hstore hextension
Previous Message Tom Lane 2019-09-05 14:35:37 Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column