Re: pg_dump dumps EVENT TRIGGER owned by extension - Mailing list pgsql-general

From Moshe Jacobson
Subject Re: pg_dump dumps EVENT TRIGGER owned by extension
Date
Msg-id CAJ4CxLnVKJNJyTib05q-jpJ==BdSrLb=0oKzexyD-B_TQdrb=Q@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump dumps EVENT TRIGGER owned by extension  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

On Mon, Dec 30, 2013 at 2:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
there seem to be two distinct bugs: CREATE EVENT TRIGGER forgets
to mark the event trigger as a member of its extension, and pg_dump
doesn't pay any attention anyway when deciding whether to dump the event
trigger.  I've committed fixes for these, but if you have an existing
extension that should have an event trigger as member, you'll need to use
ALTER EXTENSION ADD EVENT TRIGGER to clean up the mess.

Thank you, Tom.


Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump dumps EVENT TRIGGER owned by extension
Next
From: "Janek Sendrowski"
Date:
Subject: Re: bulk insert unique contraint