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

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "nekomata(at)olegk(dot)ca" <nekomata(at)olegk(dot)ca>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15338: pg_restore --disable-triggers --data-only AND schema for table is not set.
Date: 2018-08-17 18:01:31
Message-ID: 34444001534528891@myt5-f1576e7b5bad.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

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