Postgres Pro
Downloads
Home   >   mailing lists

Implement IF NOT EXISTS for CREATE PUBLICATION AND CREATE SUBSCRIPTION - Mailing list pgsql-hackers

From vignesh C
Subject Implement IF NOT EXISTS for CREATE PUBLICATION AND CREATE SUBSCRIPTION
Date
Msg-id CALDaNm0AD-y5S4jc_Yi2QyQhH5iK0x80n3gZ6x7=wQW4BEE+ag@mail.gmail.com
Whole thread Raw
Responses Re: Implement IF NOT EXISTS for CREATE PUBLICATION AND CREATE SUBSCRIPTION
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Account löschen
Next
From: Önder Kalacı
Date:
Subject: Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher