Postgres Pro
Downloads
Home   >   mailing lists

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

From Moshe Jacobson
Subject pg_dump dumps EVENT TRIGGER owned by extension
Date
Msg-id CAJ4CxLkJedV_+y73uOzhtdNa5sjxdb_mcATKE_RXUW=jNiAcJw@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump dumps EVENT TRIGGER owned by extension  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_dump dumps EVENT TRIGGER owned by extension  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

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

pgsql-general by date:

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