Thom Brown <thom@linux.com> writes:
> Would it be desirable to have ddl_command_success and
> ddl_command_failed events. These would effectively be subsets to
No, because you can't run any SQL in a failed transaction.
> This, unfortunately, introducing awkwardness with the WHEN clause
> restriction which doesn't accommodate simple equality. And looking at
> the IN part of the syntax, it looks awful: WHEN TAG IN ('DROP
> SEQUENCE' AND 'CREATE TABLE').
The syntax is using a comma, not an "AND", as seen in the tests:
create event trigger regress_event_trigger2 on ddl_command_start when tag in ('create table', 'CREATE
FUNCTION') execute procedure test_event_trigger();
> So note that I'm coming into this syntax kinda fresh, so just giving
> first impressions of the current implementation.
Thanks for that, I'm all for getting something better at the end!
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support