Re: BUG #15359: event_trigger via pg_event_trigger_ddl_commands() not returning "CREATE SEQUENCE" command

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: tarek_heiland(at)debortoli(dot)com(dot)au
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15359: event_trigger via pg_event_trigger_ddl_commands() not returning "CREATE SEQUENCE" command
Date: 2018-08-30 08:53:26
Message-ID: 87a7p4xmu8.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "PG" == PG Bug reporting form <noreply(at)postgresql(dot)org> writes:

PG> 1) Event Trigger Function (redacted to raise notice only for
PG> proscribed events)

I don't see the CREATE EVENT TRIGGER command included in your test case?

When I do your test with the addition of:

CREATE EVENT TRIGGER foo ON ddl_command_end
EXECUTE PROCEDURE admin.trg_create_set_owner();

then I see the NOTICE message for both table and sequence creation:

postgres=# CREATE SEQUENCE test_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
NOTICE: event CREATE SEQUENCE for object public.test_seq
CREATE SEQUENCE

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Kukushkin 2018-08-30 08:55:23 Re: BUG #15346: Replica fails to start after the crash
Previous Message Alvaro Herrera 2018-08-30 08:48:20 Re: BUG #15359: event_trigger via pg_event_trigger_ddl_commands() not returning "CREATE SEQUENCE" command