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

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: tarek_heiland(at)debortoli(dot)com(dot)au, 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:48:20
Message-ID: 20180830084820.s3k3dhwgkedekh7o@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2018-Aug-30, PG Bug reporting form wrote:

> 3) Test with CREATE SEQUENCE
>
> CREATE SEQUENCE test_seq
> START WITH 1
> INCREMENT BY 1
> NO MINVALUE
> NO MAXVALUE
> CACHE 1;
>
> Query returned successfully with no result in 11 msec.
>
> No event raised.

Works for me, after adding the CREATE EVENT TRIGGER command that you did
not list. (Without it, it doesn't emit the notice for CREATE TABLE
either, obviously.)

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2018-08-30 08:53:26 Re: BUG #15359: event_trigger via pg_event_trigger_ddl_commands() not returning "CREATE SEQUENCE" command
Previous Message Andrew Gierth 2018-08-30 08:44:34 Re: BUG #15352: postgresql FDW error "ERROR: ORDER BY position 0 is not in select list"