Need pg_dump not to dump extension-created triggers

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Need pg_dump not to dump extension-created triggers
Date: 2014-05-22 03:18:25
Message-ID: CAJ4CxLkz5J=JZy6+ghxrjpCiBpQJcp_eZCm2ozqiFcrK4D3VHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have an extension which, after installation, creates triggers and their
associated functions dynamically and adds the functions to the extension so
that they will be dropped with the extension.

However, there is no way to add the trigger to the extension, so pg_dump's
output still includes the definition of the trigger, even though it does
not include the definition of the corresponding function. This is causing
pg_restore to emit warnings on the CREATE TRIGGER commands.

The behavior does not change when I manually insert into pg_depend a
dependency from the trigger to the extension.

I'd like to know if the following changes can be made, as I think they will
fix this issue:

1. Add command ALTER EXTENSION ... ADD TRIGGER.
2. Modify pg_dump not to dump triggers that are dependent on an
extension.

Thanks.

P.S. I'm here at PGCon and will be speaking on Friday about this very
extension. Come say hi!

Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc. <http://www.neadwerx.com>
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Kumar 2014-05-22 06:41:57 Online recovery of Tablespace
Previous Message Joe Van Dyk 2014-05-22 02:48:37 Re: Do foreign key triggers get ran even if the key's value doesn't change?