Re: pg_dump dumps EVENT TRIGGER owned by extension

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Moshe Jacobson <moshe(at)neadwerx(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump dumps EVENT TRIGGER owned by extension
Date: 2013-12-30 18:03:38
Message-ID: 22440.1388426618@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Moshe Jacobson <moshe(at)neadwerx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2013-12-30 18:23:48 Re: Replication failed after stalling
Previous Message Moshe Jacobson 2013-12-30 17:57:05 pg_dump dumps EVENT TRIGGER owned by extension