ALTER_EVENT_TRIGGER(7pg15)

💅 ALTER EVENT TRIGGER 💅

okay so real talk — this is the ALTER EVENT TRIGGER page from the PostgreSQL 15.19 Documentation, and it's genuinely such a useful little corner of the manual. Bestie, if you've ever made an event trigger and then been like "hmm, actually I need to tweak that," this is the page for you. Let's get into it 🫶

---

✨ NAME ✨

ALTER_EVENT_TRIGGER — change the definition of an event trigger. that's it, that's the whole vibe. you made one, now you wanna mess with it. iconic behavior honestly 💅

---

🦋 SYNOPSIS 🦋

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

four whole forms, four whole moods. pick your fighter ⭐

---

🌸 DESCRIPTION 🌸

ALTER EVENT TRIGGER changes properties of an existing event trigger. lowkey that's the entire point — you've already got the trigger, you're just adjusting the vibes ✨

🚨 the fine print, and it's a big one: you must be superuser to alter an event trigger. no superuser, no slay. periodt 😭

---

🎀 PARAMETERS 🎀

• name — the name of an existing trigger to alter. like, the one you already have. not a new one. the existing one 💖
• new_owner — the user name of the new owner of the event trigger. handing over the keys, passing the crown 👑
• new_name — the new name of the event trigger. a rebrand, a glow-up, a whole new identity 🧚
• DISABLE / ENABLE [ REPLICA | ALWAYS ] — these forms configure the firing of event triggers. a disabled trigger is still known to the system, but is not executed when its triggering event occurs. so it's not gone, it's just … resting 💀. see also session_replication_role — that's the related knob, go look at it, iykyk 🔥

---

💀 COMPATIBILITY 💀

there is no ALTER EVENT TRIGGER statement in the SQL standard. nope. not a thing. this is pure PostgreSQL main character energy, no cap 🌈

---

🔗 SEE ALSO 🔗

• CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7)) — for making one in the first place 🎀
• DROP EVENT TRIGGER (DROP_EVENT_TRIGGER(7)) — for when it's time to say goodbye 😭

---

and that's the whole page bestie, every single detail intact, no facts harmed in the making of this rewrite 🌟

sign-off time: this was PostgreSQL 15.19, dated 2026, and the page is ALTER EVENT TRIGGER(7) — go forth and alter responsibly, you absolute icon 👑💖