SLONIK_SET_DROP_SEQUENCE(7)

💖 SET DROP SEQUENCE 💖

ok so this is the SLONIK SET DROP SEQUENCE page from the Slony-I 2.2.11 Documentation bestie, section 7 of the slonik manual, and it's literally about yeeting a sequence out of a replication set. short page, big slay, let's go 🦋

---

✨ NAME ✨

SET DROP SEQUENCE — Remove a sequence from a Slony-I replication set 🎀

---

✨ SYNOPSIS ✨

SET DROP SEQUENCE (options);

that's it. that's the whole vibe. 💅

---

✨ DESCRIPTION ✨

okay so what this does: it drops an existing user sequence from a replication set. bye bye sequence, you're not on this team anymore 👋

here are the options you gotta feed it:

• ORIGIN = ival — the origin node for the set. and listen, a future version of slonik might be smart enough to figure this out by itself, but for now? you're telling it. no cap. 🫶
• ID = ival — the unique ID of the sequence. this is the one, the identifier, the main character. 👑

under the hood this is using schemadocsetdropsequence(p_seq_id integer) — which is not available as a man page, so don't go looking for it, bestie, it's not out here living its own life in section 7. 🙈

---

✨ EXAMPLE ✨

here's what it looks like in the wild, fr fr:

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

look at that. clean. iconic. ⭐

---

✨ LOCKING BEHAVIOUR ✨

good news: no application-visible locking should take place. so nothing's gonna block on you while you do this. we love a low-drama operation. 🌸

---

✨ SLONIK EVENT CONFIRMATION BEHAVIOUR ✨

ok so here's the part where slonik is a little extra: it waits for the command submitted to the previous event node to be confirmed on the specified event node before it submits this command. like, it's not gonna just barrel ahead — it checks in first. patience is a virtue, periodt. 💜

---

✨ VERSION INFORMATION ✨

this command was introduced in Slony-I 1.0.5 — so it's been around a minute, it's a classic, it ate. 🔥

---

and that's the whole page!! 💖 this was pulled from the Slony-I 2.2.11 Documentation, dated 19 September 2024, and it lives in the slonik manual section 7. go forth and drop those sequences, bestie, you've got this 🧚🌈👑