pg_dump dumps EVENT TRIGGER owned by extension

From: Moshe Jacobson <moshe(at)neadwerx(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump dumps EVENT TRIGGER owned by extension
Date: 2013-12-30 17:57:05
Message-ID: CAJ4CxLkJedV_+y73uOzhtdNa5sjxdb_mcATKE_RXUW=jNiAcJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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 Tom Lane 2013-12-30 18:03:38 Re: pg_dump dumps EVENT TRIGGER owned by extension
Previous Message salah jubeh 2013-12-30 17:30:04 Re: bulk insert unique contraint