ALTER_EVENT_TRIGGER(7pg17)

💅 ALTER EVENT TRIGGER — bestie edition 💅

ok so you're flipping through the PostgreSQL 17.11 Documentation and you landed on this one — ALTER_EVENT_TRIGGER(7), the glow-up page for event triggers. slay, let's get into it ✨

---

🌸 NAME 🌸

ALTER_EVENT_TRIGGER — lowkey the whole point of this page: change the definition of an event trigger. that's it, that's the vibe. 🎀

---

🦋 SYNOPSIS 🦋

four ways to do it, bestie, pick your fighter:

ALTER EVENT TRIGGER name DISABLE
ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ]
ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER EVENT TRIGGER name RENAME TO new_name

---

✨ DESCRIPTION ✨

ALTER EVENT TRIGGER changes properties of an existing event trigger. simple as that. no cap. 💫

🚨 ok important thing before you go wild: you must be superuser to alter an event trigger. like, actually. no workaround, no sneaky trick. superuser energy only, main character privileges only. 👑

---

💖 PARAMETERS 💖

here's the breakdown, one by one, no skips:

• name — the name of an existing trigger to alter. you gotta know which one you're touching, bestie, this isn't a guessing game 🙈
• new_owner — the user name of the new owner of the event trigger. handing over the keys 🫶
• new_name — the new name of the event trigger. rebrand era 💅
• DISABLE / ENABLE [ REPLICA | ALWAYS ] — these forms configure the firing of event triggers. so like, a disabled trigger is still known to the system, it just doesn't get executed when its triggering event occurs. it's still on the roster, just benched. 😭 also go peek at session_replication_role while you're at it — that's the related lore. 🔥

---

🧚 COMPATIBILITY 🧚

there is no ALTER EVENT TRIGGER statement in the SQL standard. nope. zero. this is a PostgreSQL original, we invented it, we ate 💀✨

---

🌈 SEE ALSO 🌈

• CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7)) — the origin story 🎬
• DROP EVENT TRIGGER (DROP_EVENT_TRIGGER(7)) — the villain arc 💀

---

ok that's the whole page, you're officially an event-trigger-altering girlie now, obsessed for you fr fr 🍓💜

sign-off time: this was PostgreSQL 17.11, dated 2026, and the page is ALTER EVENT TRIGGER(7) — catch you on the next one, mwah 🎀🦋💖