DROP_TEXT_SEARCH_TEMPLATE(7pg16)

💅 DROP_TEXT_SEARCH_TEMPLATE(7) — the PostgreSQL 16.15 glow-up edit ✨

okay bestie, so we're deep in the PostgreSQL 16.15 documentation and this little icon is DROP_TEXT_SEARCH_TEMPLATE, living its best life in section 7. let me walk you through it 🫶

---

🌸 NAME 🌸

DROP_TEXT_SEARCH_TEMPLATE — literally just yeets a text search template out of existence. remove a text search template, that's the whole gig 💖

---

✨ SYNOPSIS ✨

DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]

that's it. that's the incantation. memorize it, screenshot it, put it on your lock screen 🎀

---

🦋 DESCRIPTION 🦋

DROP TEXT SEARCH TEMPLATE drops an existing text search template.

like, gone. poof. 💨

but here's the vibe check, bestie:

You must be a superuser to use this command.

no cap. if you're not a superuser, this is not your moment. this is not your era. hand the keyboard to someone with the credentials 👑

---

🌈 PARAMETERS 🌈

• IF EXISTS — do not throw an error if the text search template doesn't exist. instead, a notice gets issued, which is honestly so much gentler. it's giving "no drama, just a lil heads up" 🙈
• name — the name of an existing text search template. and yes, it can be optionally schema-qualified, so you can be all specific and fancy about it if you want 🎀
• CASCADE — automatically drops objects that depend on the text search template, and, in turn, all objects that depend on those objects. the domino effect, the chain reaction, the whole ripple. (see Section 5.14 for the full lore 👀)
• RESTRICT — refuses to drop the text search template if any objects depend on it. this is the default, so lowkey this is what you get unless you say otherwise. it's the safe, sensible, protective bestie of the two 💅

---

🍓 EXAMPLES 🍓

okay so say you wanna remove the text search template thesaurus. you literally just:

DROP TEXT SEARCH TEMPLATE thesaurus;

slay. but heads up, queen:

This command will not succeed if there are any existing text search dictionaries that use the template.

so if those dictionaries are out there being dependent, you gotta add CASCADE to drop such dictionaries along with the template. that's the move. that's the fix. 🔥

---

💜 COMPATIBILITY 💜

ngl this one's short and sweet:

There is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard.

so it's a PostgreSQL original, not a standard-SQL thing. main character energy, honestly 👑

---

⭐ SEE ALSO ⭐

go read these next, bestie, they're literally right there:

• ALTER TEXT SEARCH TEMPLATE (ALTER_TEXT_SEARCH_TEMPLATE(7))
• CREATE TEXT SEARCH TEMPLATE (CREATE_TEXT_SEARCH_TEMPLATE(7))

iykyk 💖

---

🎀 and that's the page!! footer deets so you know exactly where this came from: PostgreSQL 16.15, dated 2026, for DROP_TEXT_SEARCH_TEMPLATE(7). drink water, back up your databases, and don't drop templates you still need 🧚💜