DROP_TEXT_SEARCH_DICTIONARY(7pg15)

💅 DROP TEXT SEARCH DICTIONARY 💅

ok so bestie, real talk — this is the DROP TEXT SEARCH DICTIONARY page from the PostgreSQL 15.19 documentation, and it's genuinely one of the easier ones. no cap. it's a one-job icon: it deletes a text search dictionary. that's it. that's the whole vibe. let's get into it 🎀

---

✨ NAME ✨

DROP_TEXT_SEARCH_DICTIONARY — remove a text search dictionary 🗑️✨

like, poof. gone. bye dictionary.

---

🦋 SYNOPSIS 🦋

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

look at her. short, sweet, does exactly what she says on the tin 💅

---

🌸 DESCRIPTION 🌸

DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. that's the whole thing. main character energy, zero plot twists.

but — and this is the important bit — to run this command you must be the owner of the dictionary. not a random, not a spectator. the owner. so do a little vibe check on your permissions before you start dropping things, okay? 🫶

---

🔥 PARAMETERS 🔥

• IF EXISTS — do not throw an error if the text search dictionary doesn't exist. instead, a notice gets issued in that case. so like, it's the "no drama" flag. the dictionary isn't there? cool, we're not gonna scream about it, we'll just leave a lil note 🙈
• name — the name of an existing text search dictionary. it can optionally be schema-qualified, so you can be all specific about it if you want ✨
• CASCADE — automatically drop objects that depend on the text search dictionary, and in turn all objects that depend on those objects (see Section 5.14). it's giving domino effect, honestly 💀
• RESTRICT — refuse to drop the text search dictionary if any objects depend on it. this is the default, so if you don't say anything, this is what you get. protective queen behavior 👑

⚠️ heads up bestie: RESTRICT is the default, so if something depends on your dictionary and you didn't ask for CASCADE, the whole thing just… won't happen. plan accordingly 💖

---

🌈 EXAMPLES 🌈

ok so say you wanna remove the text search dictionary english. iconic name btw. you'd do:

DROP TEXT SEARCH DICTIONARY english;

BUT — and this is the plot twist 😭 — this command will not succeed if there are any existing text search configurations that use the dictionary. like, they're holding onto it. it's their emotional support dictionary.

so if you want to drop those configurations along with the dictionary, just add CASCADE:

DROP TEXT SEARCH DICTIONARY english CASCADE;

see? slay. simple. 🔥

---

💜 COMPATIBILITY 💜

here's the tea: there is no DROP TEXT SEARCH DICTIONARY statement in the SQL standard. at all. not a thing. it's a PostgreSQL original, iykyk 🧚

---

⭐ SEE ALSO ⭐

• ALTER TEXT SEARCH DICTIONARY (ALTER_TEXT_SEARCH_DICTIONARY(7))
• CREATE TEXT SEARCH DICTIONARY (CREATE_TEXT_SEARCH_DICTIONARY(7))

go read those next, bestie, they're the prequel and the glow-up ✨

---

and that's the whole page! 🎀 this little masterpiece comes to you from the PostgreSQL 15.19 documentation, dated 2026, and you'll find it filed under DROP TEX...ICTIONARY(7) in the manual. mwah 💋 go forth and drop responsibly 🫶💖