Moshe Jacobson <moshe@xxxxxxxxxxxx> writes: > PostgreSQL 9.3.2 > I created an extension that owns an event trigger. > When I dump the database, it puts the event trigger into the dump output > even though it's owned by the extension. > When I restore the database, the extension creates the event trigger and > the restore causes errors because the event trigger already exists. > Is this a bug? Actually, 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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
