public inbox for [email protected]  

help / color / mirror / Atom feed

From: Peter Smith <[email protected]>
To: PostgreSQL Hackers <[email protected]>
Subject: DOCS - DROP SUBSCRIPTION does not document parameter "IF EXISTS"
Date: Wed, 1 Apr 2026 17:16:00 +1100
Message-ID: <CAHut+Pv72haFerrCdYdmF6hu6o2jKcGzkXehom+sP-JBBmOVDg@mail.gmail.com> (raw)

Hi.

I happened to notice that the "DROP PUBLICATION IF EXISTS" parameter
is documented [1]
------
IF EXISTS
Do not throw an error if the publication does not exist. A notice is
issued in this case.
------

But, the equivalent "DROP SUBSCRIPTION IF EXISTS" parameter
description is missing [2].

~~~

PSA a patch to add similar documentation for DROP SUBSCRIPTION IF EXISTS.

======
[1] https://www.postgresql.org/docs/devel/sql-droppublication.html
[2] https://www.postgresql.org/docs/devel/sql-dropsubscription.html

Kind Regards,
Peter Smith.
Fujitsu Australia


Attachments:

  [application/octet-stream] v1-0001-DOCS-Add-missing-description-for-DROP-SUBSCRIPTIO.patch (1.1K, 2-v1-0001-DOCS-Add-missing-description-for-DROP-SUBSCRIPTIO.patch)
  download | inline diff:
From 76b7cd9a7a70d1db32504eb7f12ca91ea9a21dfc Mon Sep 17 00:00:00 2001
From: Peter Smith <[email protected]>
Date: Wed, 1 Apr 2026 17:10:37 +1100
Subject: [PATCH v1] DOCS - Add missing description for DROP SUBSCRIPTION IF
 EXISTS

---
 doc/src/sgml/ref/drop_subscription.sgml | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/doc/src/sgml/ref/drop_subscription.sgml b/doc/src/sgml/ref/drop_subscription.sgml
index d4f54c7170e..6e84bb0a256 100644
--- a/doc/src/sgml/ref/drop_subscription.sgml
+++ b/doc/src/sgml/ref/drop_subscription.sgml
@@ -49,6 +49,16 @@ DROP SUBSCRIPTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable
   <title>Parameters</title>
 
   <variablelist>
+   <varlistentry>
+    <term><literal>IF EXISTS</literal></term>
+    <listitem>
+     <para>
+      Do not throw an error if the subscription does not exist. A notice is
+      issued in this case.
+     </para>
+    </listitem>
+   </varlistentry>
+
    <varlistentry>
     <term><replaceable class="parameter">name</replaceable></term>
     <listitem>
-- 
2.47.3

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: DOCS - DROP SUBSCRIPTION does not document parameter "IF EXISTS"
  In-Reply-To: <CAHut+Pv72haFerrCdYdmF6hu6o2jKcGzkXehom+sP-JBBmOVDg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox