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 command is 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