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

From: "Jan Behrens" <jan(at)monso(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1597: pg_dump --verbose ignores --disable-triggers
Date: 2005-04-14 20:10:39
Message-ID: 20050414201039.646D1F1073@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1597
Logged by: Jan Behrens
Email address: jan(at)monso(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nicolas HAHN 2005-04-15 12:18:49 BUG #1598: using default 'now', or now() or CURRENT_TIMESTAMP when creating table does not work as expected
Previous Message Xavier Maysonnave 2005-04-14 16:03:52 jdbc driver return wrong medata values