Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.400.21\))
Subject: Re: DOCS - DROP SUBSCRIPTION does not document parameter "IF EXISTS"
From: Chao Li <li.evan.chao@gmail.com>
In-Reply-To: 
 <CAHut+Pv72haFerrCdYdmF6hu6o2jKcGzkXehom+sP-JBBmOVDg@mail.gmail.com>
Date: Wed, 1 Apr 2026 14:43:15 +0800
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <B28C43D4-B5D0-43FC-9DCB-2A01417A4EF3@gmail.com>
References: 
 <CAHut+Pv72haFerrCdYdmF6hu6o2jKcGzkXehom+sP-JBBmOVDg@mail.gmail.com>
To: Peter Smith <smithpb2250@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/B28C43D4-B5D0-43FC-9DCB-2A01417A4EF3%40gmail.com>
Precedence: bulk


> On Apr 1, 2026, at 14:16, Peter Smith <smithpb2250@gmail.com> wrote:
>=20
> Hi.
>=20
> 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.
> ------
>=20
> But, the equivalent "DROP SUBSCRIPTION IF EXISTS" parameter
> description is missing [2].
>=20
> ~~~
>=20
> PSA a patch to add similar documentation for DROP SUBSCRIPTION IF =
EXISTS.
>=20
> =3D=3D=3D=3D=3D=3D
> [1] https://www.postgresql.org/docs/devel/sql-droppublication.html
> [2] https://www.postgresql.org/docs/devel/sql-dropsubscription.html
>=20
> Kind Regards,
> Peter Smith.
> Fujitsu Australia
> <v1-0001-DOCS-Add-missing-description-for-DROP-SUBSCRIPTIO.patch>

Looks good. The patch uses the same phrase for =E2=80=9Cif exists=E2=80=9D=
 as the doc of =E2=80=9Cdrop publication=E2=80=9D. And I verified that a =
notice is issued:

```
evantest=3D# drop publication if exists aaa;
NOTICE:  publication "aaa" does not exist, skipping
DROP PUBLICATION
evantest=3D# drop subscription if exists aaa;
NOTICE:  subscription "aaa" does not exist, skipping
DROP SUBSCRIPTION
```

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/