SLONIK_SET_DROP_TABLE(7)

💅 SLONIK SET DROP TABLE 💅

okay bestie, welcome to the SET DROP TABLE page of the Slony-I manual — this is the Slony-I 2.2.11 docs, and we're about to yeet a table out of a replication set. no cap. ✨

---

🎀 NAME 🎀

SET DROP TABLE — literally just: remove a table from a Slony-I replication set. that's the whole vibe. 🦋

---

✨ SYNOPSIS ✨

SET DROP TABLE (options);

---

💖 DESCRIPTION 💖

Drop a table from a replication set. bye babe, we hardly knew ye 🫶

ORIGIN = ival

Origin node for the set. okay so listen — a future version of slonik might figure out this information by itself, but right now? you're typing it in, bestie. ival is the origin node for the set.

ID = ival

Unique ID of the table. that's your table's ID, the unique one, the main character. 👑

---

under the hood this uses schemadocsetdroptable(p_tab_id integer) [not available as a man page] — so if you went looking for that man page, it's not there, that's not a you problem. 🙈

---

🌸 EXAMPLE 🌸

here's what it actually looks like in the wild, and yes this is exact, copy it as-is:

     SET DROP TABLE (
     ORIGIN = 1,
     ID = 20
     );

ate. no crumbs. 🔥

---

🔒 LOCKING BEHAVIOUR 🔒

this one's important, don't skim it.

This operation must acquire an exclusive lock on the table being dropped from replication, because it has to alter it to drop the replication trigger. that's not optional, that's not a suggestion, that's the price of admission.

And on subscriber nodes? this also involves adding back any rules/triggers that have been hidden. so like, there's cleanup happening. be aware. 💀

---

📬 SLONIK EVENT CONFIRMATION BEHAVIOUR 📬

Slonik waits for the command submitted to the previous event node to be confirmed on the specified event node before submitting this command. it's giving patient. it's giving waiting its turn. it's giving confirmed-before-proceeding energy. ⭐

---

🕰️ VERSION INFORMATION 🕰️

This command was introduced in Slony-I 1.0.5. an icon, a legend, been here since day one fr fr. 👑

---

that's the whole page bestie — go forth, drop that table, and remember the exclusive lock. iykyk. 💜

mwah 💋 — this was the Slony-I 2.2.11 Documentation, dated 19 September 2024, for SLONIK SET DROP TABLE(7). love u, bye 🎀✨