pg_dump vs data-only dumps vs --disable-triggers - Mailing list pgsql-hackers

From Tom Lane
Subject pg_dump vs data-only dumps vs --disable-triggers
Date
Msg-id 12664.1216941114@sss.pgh.pa.us
Whole thread Raw
Responses Re: pg_dump vs data-only dumps vs --disable-triggers  (Andrew Dunstan <andrew@dunslane.net>)
Re: pg_dump vs data-only dumps vs --disable-triggers  (Stephen Frost <sfrost@snowman.net>)
Re: pg_dump vs data-only dumps vs --disable-triggers  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
There's some fairly squirrely logic in pg_dump/pg_restore that tries to
detect whether it's doing a data-only operation, ie, no schema
information is to be dumped or restored.  The reason it wants to
know this is to decide whether to enable the --disable-triggers
code.  However, since --disable-triggers is off by default and has
to be manually requested, I'm not sure why we've got all this extra
complexity in there.  (Actually, I'm sure the reason is that that
code predates the existence of the --disable-triggers switch, but
anyway...)

Simon's patch to split up --schema-only into two switches has broken
this logic, but I'm inclined to just rip it out rather than trying
to fix it.  If the user says --disable-triggers, he should get
trigger disable commands around the data part of the dump, no matter
what he said or didn't say about schema dumping.

Objections?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?
Next
From: Tom Lane
Date:
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?