DROP_TEXT_SEARCH_CONFIGURATION(7pg15)

💅 DROP TEXT SEARCH CONFIGURATION 💅

okay bestie, welcome to the DROP TEXT SEARCH CONFIGURATION page — this is the PostgreSQL 15.19 Documentation entry (manual 7pg15), and yes it's a whole little era of its own. buckle up 🎀

---

✨ NAME ✨

DROP_TEXT_SEARCH_CONFIGURATION — bestie, this is literally the "remove a text search configuration" command. that's it, that's the vibe. 💖

---

✨ SYNOPSIS ✨

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

look at her. iconic square brackets, main character energy. 💅

---

🌸 DESCRIPTION 🌸

okay so DROP TEXT SEARCH CONFIGURATION drops an existing text search configuration. gone. deleted. not me being dramatic, it's just what she does 💀

but listen — to actually run this command you must be the owner of the configuration. no ownership, no dropping. that's the rule, periodt. 👑

---

🦋 PARAMETERS 🦋

• IF EXISTS — do not throw an error if the text search configuration doesn't exist. ngl that's so forgiving of her 🥺 a notice is issued in this case, so you still get a little whisper about it.
• name — the name (optionally schema-qualified) of an existing text search configuration. just point at her and say bye 🫶
• CASCADE — automatically drop objects that depend on the text search configuration, and in turn all objects that depend on those objects (see Section 5.14). it's giving domino effect, lowkey 🌈
• RESTRICT — refuse to drop the text search configuration if any objects depend on it. this one is ✨the default✨ so if you don't say anything, she's already in her cautious era 🙈

---

🍓 EXAMPLES 🍓

remove the text search configuration my_english:

DROP TEXT SEARCH CONFIGURATION my_english;

⚠️ heads up bestie: this command will not succeed if there are any existing indexes that reference the configuration in to_tsvector calls. if you're in that situation, add CASCADE to drop such indexes along with the text search configuration. highkey important, don't skip this one 😭

---

🧚 COMPATIBILITY 🧚

there is no DROP TEXT SEARCH CONFIGURATION statement in the SQL standard. so she's built different, and that's on that 💅✨

---

⭐ SEE ALSO ⭐

• ALTER TEXT SEARCH CONFIGURATION (ALTER_TEXT_SEARCH_CONFIGURATION(7))
• CREATE TEXT SEARCH CONFIGURATION (CREATE_TEXT_SEARCH_CONFIGURATION(7))

go read those too, iykyk 📚💜

---

and that's the whole page, bestie!! mwah 💖 this little beauty is from PostgreSQL 15.19, and she's dated 2026 — go off, queen 👑🎀