Implement IF NOT EXISTS for CREATE PUBLICATION AND CREATE SUBSCRIPTION

From: vignesh C <vignesh21(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Implement IF NOT EXISTS for CREATE PUBLICATION AND CREATE SUBSCRIPTION
Date: 2023-03-12 14:38:23
Message-ID: CALDaNm0AD-y5S4jc_Yi2QyQhH5iK0x80n3gZ6x7=wQW4BEE+ag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Currently we don't support "IF NOT EXISTS" for Create publication and
Create subscription, I felt it would be useful to add this "IF NOT
EXISTS" which will create publication/subscription only if the object
does not exist.
Attached patch for handling the same.
Thoughts?

Regards,
Vignesh

Attachment Content-Type Size
v1-0001-Implement-IF-NOT-EXISTS-for-CREATE-PUBLICATION-AN.patch text/x-patch 11.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Önder Kalacı 2023-03-12 15:07:17 Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Previous Message Alvaro Herrera 2023-03-12 13:22:50 Re: Account löschen