Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg_dump dumps EVENT TRIGGER owned by extension
Date
Msg-id 22440.1388426618@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump dumps EVENT TRIGGER owned by extension  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-general
Tree view 
Moshe Jacobson <moshe@neadwerx.com> 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?

Yup.

            regards, tom lane

pgsql-general by date:

Previous
From: Moshe Jacobson
Date:
Subject: pg_dump dumps EVENT TRIGGER owned by extension
Next
From: Sergey Konoplev
Date:
Subject: Re: Replication failed after stalling