Tom Lane writes:
> If you have the dump in a text file you could just edit it and remove
> that line (it's only about a dozen lines in, typically). Otherwise
> you could delete it with sed or the like, roughly
>
> pg_restore dumpfile | sed s'/^SELECT pg_catalog.set_config('search_path', '',
> f
On 9/5/19 7:35 AM, Tom Lane wrote:
Lele Gaifax 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 thi
Lele Gaifax writes:
> I'm hitting a problem very similar to the one described here[1]
Yeah, nothing's been done about that yet :-(
> where several of those columns are HSTOREs. Trying to restore a dump I get the
> same error: "ERROR: operator does not exist: public.hstore = public.hstore".
> Th
On 9/5/19 7:16 AM, Lele Gaifax wrote:
Hi all,
I'm hitting a problem very similar to the one described here[1]: one of my
databases have the following trigger
CREATE TRIGGER trg_dn_customer_contents_950_reset_usable
BEFORE UPDATE
ON dn.customer_contents
FOR EACH ROW
Hi all,
I'm hitting a problem very similar to the one described here[1]: one of my
databases have the following trigger
CREATE TRIGGER trg_dn_customer_contents_950_reset_usable
BEFORE UPDATE
ON dn.customer_contents
FOR EACH ROW
WHEN (OLD.usable IS NOT NULL AND OLD.usabl
