DROP_TEXT_SEARCH_CONFIGURATION(7pg13)

💅 DROP TEXT SEARCH CONFIGURATION 💅

okay bestie, so you know how the DROP TEXT... page is a whole thing in the PostgreSQL 13.23 docs? yeah, that's this one — it's the DROP_TEXT_SEARCH_CONFIGURATION(7pg13) page and we're gonna get you fluent in it 🫶

---

✨ NAME ✨

DROP_TEXT_SEARCH_CONFIGURATION — literally just yeets a text search configuration out of existence 🗑️✨

🌸 SYNOPSIS 🌸

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

🎀 DESCRIPTION 🎀

so DROP TEXT SEARCH CONFIGURATION drops an existing text search configuration. that's it, that's the vibe 💅

important though — to run this command you must be the owner of the configuration. no owner, no drop, periodt 👑

🦋 PARAMETERS 🦋

• IF EXISTS — don't throw an error if the text search configuration doesn't exist. instead a notice is issued in this case, so it's giving "gentle heads up" not "full dramatic meltdown" 😭
• name — the name (optionally schema-qualified) of an existing text search configuration 🏷️
• 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, ngl 🁢🁢🁢
• RESTRICT — refuse to drop the text search configuration if any objects depend on it. this is the default, so if you don't say anything, this is what you get 🤫

💖 EXAMPLES 💖

remove the text search configuration my_english:

DROP TEXT SEARCH CONFIGURATION my_english;

⚠️ heads up: this command will not succeed if there are any existing indexes that reference the configuration in to_tsvector calls. add CASCADE to drop such indexes along with the text search configuration. no cap, it will just refuse 🙈

🌈 COMPATIBILITY 🌈

there is no DROP TEXT SEARCH CONFIGURATION statement in the SQL standard. so this one's a PostgreSQL original, main character energy only 👑

⭐ SEE ALSO ⭐

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

---

okay that's the whole page bestie, you ate that 🍓💜 this one's from PostgreSQL 13.23, published 2025 — DROP TEXT...IGURATION(7), and that's the tea ☕✨ go drop some configurations (responsibly, with RESTRICT energy) 🧚🎀