Request a Demo
Home   >   mailing lists

Re: BUG #17576: Event_trigger ddl_command_end not firing during CREATE PROCEDURE - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17576: Event_trigger ddl_command_end not firing during CREATE PROCEDURE
Date
Msg-id CAKFQuwabg+p7krYRaZ-UROcwuFfGmwhQJWPyQSNnWfrytcwJAQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17576: Event_trigger ddl_command_end not firing during CREATE PROCEDURE  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
On Fri, Aug 5, 2022 at 10:37 AM David G. Johnston <david.g.johnston@gmail.com> wrote:

postgres=# CREATE EVENT TRIGGER tg_change_obj_owner ON ddl_command_end
        EXECUTE FUNCTION public.evt_warn();
CREATE EVENT TRIGGER
postgres=# create table evt_table ( id serial primary key) ;
ERROR:  relation "evt_table" already exists

Doesn't really matter but oops...

postgres=# create table evt_table_two ( id serial primary key) ;
ERROR:  Event
CONTEXT:  PL/pgSQL function evt_warn() line 1 at RAISE

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17576: Event_trigger ddl_command_end not firing during CREATE PROCEDURE
Next
From: PG Bug reporting form
Date:
Subject: BUG #17577: pg_ctl promote is not preemptive in archive recovery