Re: Add CREATE support to event triggers

Jim Nasby wrote:
> On 2/6/14, 11:20 AM, Alvaro Herrera wrote:
> >NOTICE:  JSON blob: {
> >     "definition": [
> >         {
> >             "clause": "owned",
> >             "fmt": "OWNED BY %{owner}D",
> >             "owner": {
> >                 "attrname": "a",
> >                 "objname": "t1",
> >                 "schemaname": "public"
> >             }
> >         }
> >     ],
> >     "fmt": "ALTER SEQUENCE %{identity}D %{definition: }s",
> >     "identity": {
> >         "objname": "t1_a_seq",
> >         "schemaname": "public"
> >     }
> >}
> >NOTICE:  expanded: ALTER SEQUENCE public.t1_a_seq OWNED BY public.t1.a
> 
> Apologies if this has been discussed and I missed it, but shouldn't part of the JSON be a field that indicates what
commandis being run? It doesn't seem wise to conflate detecting what the command is with the overall format string.
 

That's reported as a separate field by the
pg_event_trigger_creation_commands function.

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