2

In my question,

Does the SQL Standard mention trigger events on DDL (ALTER, CREATE, DROP)?

I address the fact that many databases are addressing this need with ad-hoc functionality. Do we need one tag for each database for this?

1 Answer 1

3

No, we don't

I may have actually created , which is the PostgreSQL name of this functionality. But I'll go on the record saying "DDL Trigger" isn't a shabby name.

While ALTER EXTENSION is neither really DDL nor DML and it's covered by an Event Trigger it would seem that this is such a small thing it makes sense to merge them.

I don't even care which one we get the synonym will auto-correct to the other and that's fine.

2
  • 1
    I have added a synonym event-trigger -> ddl-trigger. Did I understand your point correctly? it is easy to undo if not.
    – Paul White Mod
    Nov 16, 2018 at 6:06
  • @PaulWhite that works for me. Nov 20, 2018 at 16:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .