Re: BUG #15338: pg_restore --disable-triggers --data-only AND schema for table is not set. - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #15338: pg_restore --disable-triggers --data-only AND schema for table is not set.
Date
Msg-id 34444001534528891@myt5-f1576e7b5bad.qloud-c.yandex.net
Whole thread Raw
In response to BUG #15338: pg_restore --disable-triggers --data-only AND schema fortable is not set.  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15338: pg_restore --disable-triggers --data-only AND schema for table is not set.
List pgsql-bugs
Hello
I can confirm this and i got reproducible testcase:
create database bug15338;
\c bug15338
create schema testschema;
create table testschema.test (value text);
insert into testschema.test values ('bug 15338 verify');

Plain format looks good:
/usr/lib/postgresql/10/bin/pg_dump bug15338  --disable-triggers --data-only # all ok!

But custom and dir formats are wrong:
/usr/lib/postgresql/10/bin/pg_dump bug15338  --disable-triggers --data-only -Fc --file bug15338.pgdump
/usr/lib/postgresql/10/bin/pg_restore bug15338.pgdump --disable-triggers --data-only
Produces wrong ALTER TABLE test DISABLE TRIGGER ALL, not testschema.test

Current master has this bug too.

regards, Sergei


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Row exists in a table that violates Foreign key constraint
Next
From: Tom Lane
Date:
Subject: Re: BUG #15338: pg_restore --disable-triggers --data-only AND schema for table is not set.