Re: [GENERAL] pg_dump not dropping event trigger - Mailing list pgsql-general

From Greg Atkins
Subject Re: [GENERAL] pg_dump not dropping event trigger
Date
Msg-id 20170723065916.yarirrvszn6nf3w6@gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg_dump not dropping event trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] pg_dump not dropping event trigger  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom,

would you like a bug report to track this?

On Sat, Jul 22, 2017 at 07:00:03PM -0400, Tom Lane wrote:
> Greg Atkins <void.is.meaning@gmail.com> writes:
> > I have a DB with an event trigger, which I am dumping with
> > pg_dump -Fc --no-acl --no-owner [db_name] > [dump_file]
>
> > In my dump file, I can't find any DROP EVENT TRIGGER statement.
>
> Well, you wouldn't, for lack of -c ... but yes, it seems you don't
> get a DROP EVENT TRIGGER even with that.  Will fix.
>
>             regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_dump not dropping event trigger
Next
From: "dilaz03 ."
Date:
Subject: [GENERAL] Perfomance of IN-clause with many elements and possible solutions