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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers