BUG #1597: pg_dump --verbose ignores --disable-triggers

Started by Jan B.about 21 years ago2 messagesbugs
Jump to latest
#1Jan B.
jan@monso.de

The following bug has been logged online:

Bug reference: 1597
Logged by: Jan Behrens
Email address: jan@monso.de
PostgreSQL version: 8.0.1
Operating system: Linux 2.4.29
Description: pg_dump --verbose ignores --disable-triggers
Details:

pg_dump -a --disable-triggers

gives a different output than

pg_dump -a --disable-triggers -v
or
pg_dump -a --disable-triggers --verbose

When verbose mode is NOT turned on, the output contains:

--
-- Data for Name: address_incoming; Type: TABLE DATA; Schema: mail; Owner:
postgresql
--

-- Disable triggers
UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid =
'address_incoming'::pg_catalog.regclass;

COPY address_incoming (client, id, address, mailbox, path) FROM stdin;
12 119118 118110 118413
12 119012 118313 118510
[...]

WITH verbose mode, the output looks like this:

--
-- TOC entry 1959 (class 0 OID 98297)
-- Dependencies: 1392
-- Data for Name: address_incoming; Type: TABLE DATA; Schema: mail; Owner:
postgresql
--

COPY address_incoming (client, id, address, mailbox, path) FROM stdin;
12 119118 118110 118413
12 119012 118313 118510
[...]

When verbose mode is turned on, the output for disabling (and enabling) the
triggers is omitted.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Jan B. (#1)
Re: BUG #1597: pg_dump --verbose ignores --disable-triggers

"Jan Behrens" <jan@monso.de> writes:

pg_dump -a --disable-triggers
gives a different output than
pg_dump -a --disable-triggers -v

Fixed for next release. Thanks for the report.

regards, tom lane