DROP_EVENT_TRIGGER(7pg13)

💅 DROP EVENT TRIGGER 💅

ok so this is the DROP EVENT TRIGGER page from the PostgreSQL 13.23 docs, and it's honestly kind of a short one but it's still iconic, so let's get into it bestie 🫶

---

✨ NAME ✨

DROP_EVENT_TRIGGER — yeet an event trigger out of existence, remove it, delete it, it's gone girl 💀

---

🌸 SYNOPSIS 🌸

DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]

look at that syntax, so clean, so simple, main character energy fr fr ✨

---

🦋 DESCRIPTION 🦋

DROP EVENT TRIGGER removes an existing event trigger. that's the whole vibe. one job, does it well 💅

ok but here's the important bit — to actually run this command, the current user must be the owner of the event trigger. so like, you can't just roll up and start dropping other people's triggers, that's not the move, the database said no 🙈

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the event trigger doesn't exist. instead a notice is issued in this case. so like, no dramatic meltdown if the thing is already gone, just a lil heads up 💌
• name — the name of the event trigger you're removing. yes, that's it, that's the parameter, you literally just say which one 🎯
• CASCADE — automatically drop objects that depend on the trigger, and in turn all objects that depend on those objects (see Section 5.14). it's giving domino effect, it's giving chain reaction, it's giving be careful bestie 🔥 😭
• RESTRICT — refuse to drop the trigger if any objects depend on it. this is the default, so if you don't say anything it's already protecting you, no cap 🛡️

---

⭐ EXAMPLES ⭐

destroy the trigger snitch:

DROP EVENT TRIGGER snitch;

and the snitch is GONE. bye. not me making an example of it 💀 🎀

---

🧚 COMPATIBILITY 🧚

there is no DROP EVENT TRIGGER statement in the SQL standard. nope. not a thing. this is a PostgreSQL original, iykyk 💜

---

🌈 SEE ALSO 🌈

• CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7))
• ALTER EVENT TRIGGER (ALTER_EVENT_TRIGGER(7))

go read those too, they're the whole trilogy and you deserve the full lore 🫶✨

---

lowkey reminder bestie: RESTRICT is the default, so if you want the cascade chaos you gotta ask for it 💅

---

ok that's the whole page!! slayed, no notes 💖 this was PostgreSQL 13.23 documentation, dated 2025 — mwah, stan, periodt 🎀🦋👑