Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group