Re: BUG #17576: Event_trigger ddl_command_end not firing during CREATE PROCEDURE

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: gabriel(dot)franco(at)quintoandar(dot)com(dot)br, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17576: Event_trigger ddl_command_end not firing during CREATE PROCEDURE
Date: 2022-08-05 17:39:33
Message-ID: CAKFQuwabg+p7krYRaZ-UROcwuFfGmwhQJWPyQSNnWfrytcwJAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Aug 5, 2022 at 10:37 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-08-05 18:30:36 BUG #17577: pg_ctl promote is not preemptive in archive recovery
Previous Message David G. Johnston 2022-08-05 17:37:34 Re: BUG #17576: Event_trigger ddl_command_end not firing during CREATE PROCEDURE