Re: Identify missing publications from publisher while create/alter subscription.

2022-03-31 Thread Amit Kapila
On Wed, Mar 30, 2022 at 9:54 PM vignesh C wrote: > > On Wed, Mar 30, 2022 at 5:42 PM Bharath Rupireddy > wrote: > > Your suggestion looks valid, I have modified it as suggested. > Additionally I have removed Create subscription with multiple > non-existent publications and changed add publication

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-30 Thread vignesh C
On Wed, Mar 30, 2022 at 5:42 PM Bharath Rupireddy wrote: > > On Wed, Mar 30, 2022 at 5:37 PM Bharath Rupireddy > wrote: > > > > On Wed, Mar 30, 2022 at 4:29 PM Amit Kapila wrote: > > > > > > On Wed, Mar 30, 2022 at 12:22 PM vignesh C wrote: > > > > > > > > I have made the changes for this, atta

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-30 Thread Bharath Rupireddy
On Wed, Mar 30, 2022 at 5:37 PM Bharath Rupireddy wrote: > > On Wed, Mar 30, 2022 at 4:29 PM Amit Kapila wrote: > > > > On Wed, Mar 30, 2022 at 12:22 PM vignesh C wrote: > > > > > > I have made the changes for this, attached v17 patch has the changes > > > for the same. > > > > > > > The patch l

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-30 Thread Bharath Rupireddy
On Wed, Mar 30, 2022 at 4:29 PM Amit Kapila wrote: > > On Wed, Mar 30, 2022 at 12:22 PM vignesh C wrote: > > > > I have made the changes for this, attached v17 patch has the changes > > for the same. > > > > The patch looks good to me. I have made minor edits in the comments > and docs. See the a

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-30 Thread Amit Kapila
On Wed, Mar 30, 2022 at 12:22 PM vignesh C wrote: > > I have made the changes for this, attached v17 patch has the changes > for the same. > The patch looks good to me. I have made minor edits in the comments and docs. See the attached and let me know what you think? I intend to commit this tomor

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-29 Thread vignesh C
On Wed, Mar 30, 2022 at 11:22 AM Amit Kapila wrote: > > On Tue, Mar 29, 2022 at 8:11 PM vignesh C wrote: > > > > On Tue, Mar 29, 2022 at 11:02 AM Amit Kapila > > wrote: > > > > > > > Thanks for the suggestion, I have changed the patch as suggested. > > Attached v16 patch has the changes for the

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-29 Thread Amit Kapila
On Tue, Mar 29, 2022 at 8:11 PM vignesh C wrote: > > On Tue, Mar 29, 2022 at 11:02 AM Amit Kapila wrote: > > > > Thanks for the suggestion, I have changed the patch as suggested. > Attached v16 patch has the changes for the same. > Thanks, I have one more comment. postgres=# Alter subscription

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-29 Thread vignesh C
On Tue, Mar 29, 2022 at 4:12 PM Amit Kapila wrote: > > On Tue, Mar 29, 2022 at 11:01 AM Amit Kapila wrote: > > > > On Sat, Mar 26, 2022 at 7:53 PM vignesh C wrote: > > > > > > The patch was not applying on HEAD, attached patch which is rebased on > > > top of HEAD. > > > > > > > IIUC, this patch

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-29 Thread vignesh C
ggestion, I have changed the patch as suggested. Attached v16 patch has the changes for the same. Regards, Vignesh From 4232956ff31192e903736e921b92aac06243c171 Mon Sep 17 00:00:00 2001 From: Vigneshwaran C Date: Sat, 26 Mar 2022 19:43:27 +0530 Subject: [PATCH v16] Identify missing publications fro

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-29 Thread Amit Kapila
On Tue, Mar 29, 2022 at 11:01 AM Amit Kapila wrote: > > On Sat, Mar 26, 2022 at 7:53 PM vignesh C wrote: > > > > The patch was not applying on HEAD, attached patch which is rebased on > > top of HEAD. > > > > IIUC, this patch provides an option that allows us to give an error if > while creating/

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-28 Thread Amit Kapila
On Sat, Mar 26, 2022 at 7:53 PM vignesh C wrote: > > The patch was not applying on HEAD, attached patch which is rebased on > top of HEAD. > IIUC, this patch provides an option that allows us to give an error if while creating/altering subcsiction, user gives non-existant publications. I am not s

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-26 Thread vignesh C
Vigneshwaran C Date: Sat, 26 Mar 2022 19:43:27 +0530 Subject: [PATCH v15] Identify missing publications from publisher while create/alter subscription. Creating/altering subscription is successful when we specify a publication which does not exist in the publisher. This patch checks if the s

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-22 Thread vignesh C
utube.org/patch_37_2957.log The attached v15 patch is rebased on top of HEAD. Regards, Vignesh From fa175c7c823dc9fbcca7676ddec944430da81022 Mon Sep 17 00:00:00 2001 From: Vigneshwaran C Date: Tue, 22 Mar 2022 15:09:13 +0530 Subject: [PATCH v15] Identify missing publications from publisher while

Re: Identify missing publications from publisher while create/alter subscription.

2022-03-21 Thread Andres Freund
On 2022-02-13 19:34:05 +0530, vignesh C wrote: > Thanks for the comments, the attached v14 patch has the changes for the same. The patch needs a rebase, it currently fails to apply: http://cfbot.cputube.org/patch_37_2957.log

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-15 Thread Ashutosh Sharma
Thanks for working on the review comments. The changes in the new patch look good to me. I am marking it as ready to commit. -- With Regards, Ashutosh Sharma. On Sun, Feb 13, 2022 at 7:34 PM vignesh C wrote: > > On Fri, Feb 11, 2022 at 7:14 PM Ashutosh Sharma wrote: > > > > I have spent little

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-14 Thread Ashutosh Sharma
Thanks for working on my review comments. I'll take a look at the new changes and let you know my comments, if any. I didn't get a chance to check it out today as I was busy reviewing some other patches, but I'll definitely take a look at the new patch in a day or so and let you know my feedback.

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-14 Thread Ashutosh Sharma
On Sun, Feb 13, 2022 at 7:32 PM vignesh C wrote: > > On Thu, Feb 10, 2022 at 3:15 PM Ashutosh Sharma wrote: > > > > On Wed, Feb 9, 2022 at 11:53 PM Euler Taveira wrote: > > > > > > On Wed, Feb 9, 2022, at 12:06 PM, Ashutosh Sharma wrote: > > > > > > Just wondering if we should also be detecting

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-13 Thread vignesh C
ublication -> publications (in the 4th line : throw an error if any > of the publication doesn't exist) > > This applies for both CREATE and ALTER subscription commands. Modified Thanks for the comments, the attached v14 patch has the changes for the same. Regard,s Vignesh From

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-13 Thread vignesh C
On Thu, Feb 10, 2022 at 3:15 PM Ashutosh Sharma wrote: > > On Wed, Feb 9, 2022 at 11:53 PM Euler Taveira wrote: > > > > On Wed, Feb 9, 2022, at 12:06 PM, Ashutosh Sharma wrote: > > > > Just wondering if we should also be detecting the incorrect conninfo > > set with ALTER SUBSCRIPTION command as

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-11 Thread Ashutosh Sharma
I have spent little time looking at the latest patch. The patch looks to be in good shape as it has already been reviewed by many people here, although I did get some comments. Please take a look and let me know your thoughts. + /* Try to connect to the publisher. */ + wrconn = walrcv_connect

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-10 Thread Ashutosh Sharma
On Wed, Feb 9, 2022 at 11:53 PM Euler Taveira wrote: > > On Wed, Feb 9, 2022, at 12:06 PM, Ashutosh Sharma wrote: > > Just wondering if we should also be detecting the incorrect conninfo > set with ALTER SUBSCRIPTION command as well. See below: > > -- try creating a subscription with incorrect con

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-09 Thread Euler Taveira
On Wed, Feb 9, 2022, at 12:06 PM, Ashutosh Sharma wrote: > Just wondering if we should also be detecting the incorrect conninfo > set with ALTER SUBSCRIPTION command as well. See below: > > -- try creating a subscription with incorrect conninfo. the command fails. > postgres=# create subscription

Re: Identify missing publications from publisher while create/alter subscription.

2022-02-09 Thread Ashutosh Sharma
Just wondering if we should also be detecting the incorrect conninfo set with ALTER SUBSCRIPTION command as well. See below: -- try creating a subscription with incorrect conninfo. the command fails. postgres=# create subscription sub1 connection 'host=localhost port=5490 dbname=postgres' publicat

Re: Identify missing publications from publisher while create/alter subscription.

2021-11-13 Thread Bharath Rupireddy
On Sat, Nov 13, 2021 at 12:50 PM vignesh C wrote: > > Thanks for the comments, the attached v13 patch has the fixes for the same. Thanks for the updated v13 patch. I have no further comments, it looks good to me. Regards, Bharath Rupireddy.

Re: Identify missing publications from publisher while create/alter subscription.

2021-11-12 Thread vignesh C
on fails with connection to a > non-existent database"); Modified Thanks for the comments, the attached v13 patch has the fixes for the same. Regards, Vignesh From f85203bf95359dac6fb2eea3b973be7ceaadf4e1 Mon Sep 17 00:00:00 2001 From: Vignesh C Date: Tue, 9 Nov 2021 20:30:47 +0530 Subject:

Re: Identify missing publications from publisher while create/alter subscription.

2021-11-09 Thread Bharath Rupireddy
On Tue, Nov 9, 2021 at 9:27 PM vignesh C wrote: > Attached v12 version is rebased on top of Head. Thanks for the patch. Here are some comments on v12: 1) I think ERRCODE_TOO_MANY_ARGUMENTS isn't the right error code, the ERRCODE_UNDEFINED_OBJECT is more meaningful. Please change. + ereport(ERROR

Re: Identify missing publications from publisher while create/alter subscription.

2021-11-09 Thread vignesh C
;, "pub4" do not exist in the publisher Whereas in case of the query we use single quotes, so quote_literal is used to differentiate and handle accordingly. Attached v12 version is rebased on top of Head. Regards, Vignesh From 935841351cb264db6b8d8ddb7c83adcea08e0c76 Mon Sep 17 00:00:

Re: Identify missing publications from publisher while create/alter subscription.

2021-09-27 Thread Jaime Casanova
On Thu, Aug 26, 2021 at 07:49:49PM +0530, vignesh C wrote: > On Thu, Jul 15, 2021 at 5:57 PM vignesh C wrote: > > > > On Tue, Jul 6, 2021 at 8:09 PM vignesh C wrote: > > > > > > On Wed, Jun 30, 2021 at 8:23 PM vignesh C wrote: > > > > > > > > On Sun, Jun 6, 2021 at 11:55 AM vignesh C wrote: > >

Re: Identify missing publications from publisher while create/alter subscription.

2021-08-26 Thread vignesh C
522ba31829c76e6c4c2069f2806c653aecf62 Mon Sep 17 00:00:00 2001 From: Vigneshwaran C Date: Thu, 26 Aug 2021 16:32:56 +0530 Subject: [PATCH v11] Identify missing publications from publisher while create/alter subscription. Creating/altering subscription is successful when we specify a publication whi

Re: Identify missing publications from publisher while create/alter subscription.

2021-07-15 Thread vignesh C
; > HEAD. > > The patch was not applying on the head, attached patch which is rebased on > HEAD. The patch was not applying on the head, attached patch which is rebased on HEAD. Regards, Vignesh From 09bd61d8ebcc4b5119048aeb7274bff2bdcae794 Mon Sep 17 00:00:00 2001 From: vignesh Dat

Re: Identify missing publications from publisher while create/alter subscription.

2021-07-06 Thread vignesh C
9130a6d393c8c020234747865368596a3c4702 Mon Sep 17 00:00:00 2001 From: vignesh Date: Tue, 6 Jul 2021 19:54:11 +0530 Subject: [PATCH v11] Identify missing publications from publisher while create/alter subscription. Creating/altering subscription is successful when we specify a publication which does

Re: Identify missing publications from publisher while create/alter subscription.

2021-06-30 Thread vignesh C
The patch was not applying on the head, attached patch which is rebased on HEAD. Regards, Vignesh From 65b2eb5c380f09faec0e72edff0b8e84e9b9267c Mon Sep 17 00:00:00 2001 From: vignesh Date: Wed, 30 Jun 2021 20:02:08 +0530 Subject: [PATCH v11] Identify missing publications from publisher while

Re: Identify missing publications from publisher while create/alter subscription.

2021-06-05 Thread vignesh C
> > > Yeah, we should be using local wrconn, otherwise there can be > > > consequences, see the patches at [1]. Thanks for pointing out this. > > Modified. > > Thanks for the comments, the attached patch has the fix for the same. The patch was not applying on the h

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-07 Thread vignesh C
rconn, I think you should use a local variable? > > > > Yeah, we should be using local wrconn, otherwise there can be > > consequences, see the patches at [1]. Thanks for pointing out this. Modified. Thanks for the comments, the attached patch has the fix for the same. Regar

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-07 Thread Dilip Kumar
On Fri, May 7, 2021 at 5:38 PM Bharath Rupireddy wrote: > > On Fri, May 7, 2021 at 11:50 AM Dilip Kumar wrote: > > > > On Thu, May 6, 2021 at 7:22 PM vignesh C wrote: > > > > > > > Some comments: > > 1. > > I don't see any change in pg_dump.c, don't we need to dump this option? > > I don't think

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-07 Thread Bharath Rupireddy
On Fri, May 7, 2021 at 11:50 AM Dilip Kumar wrote: > > On Thu, May 6, 2021 at 7:22 PM vignesh C wrote: > > > > Some comments: > 1. > I don't see any change in pg_dump.c, don't we need to dump this option? I don't think it is necessary there as the default value of the validate_publication is fal

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-06 Thread Dilip Kumar
On Thu, May 6, 2021 at 7:22 PM vignesh C wrote: > Some comments: 1. I don't see any change in pg_dump.c, don't we need to dump this option? 2. + /* Try to connect to the publisher. */ + wrconn = walrcv_connect(sub->conninfo, true, sub->name, &err); + if (!wrconn) + ereport(ERROR, + (errmsg("coul

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-06 Thread Japin Li
On Thu, 06 May 2021 at 21:52, vignesh C wrote: > On Thu, May 6, 2021 at 9:08 AM Japin Li wrote: >> 3) Should we free the memory when finish the check_publications()? >> + publicationsCopy = list_copy(publications); > > I felt this list entries will be deleted in the success case, in error

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-06 Thread vignesh C
s we will be exiting. Thoughts? > 4) It is better wrap the word "streaming" with quote. Also, should we add > 'no "validate_publication"' comment for validate_publication parameters? >

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-05 Thread Japin Li
On Tue, 04 May 2021 at 21:20, vignesh C wrote: > On Tue, May 4, 2021 at 2:37 PM Bharath Rupireddy > wrote: >> >> On Mon, May 3, 2021 at 7:59 PM vignesh C wrote: >> > Thanks for the comments, these comments are handle in the v7 patch >> > posted in my earlier mail. >> >> Thanks. Some comments o

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-04 Thread Bharath Rupireddy
On Tue, May 4, 2021 at 6:50 PM vignesh C wrote: > Thanks for the comments, Attached patch has the fixes for the same. Thanks! I took a final look over the v8 patch, it looks good to me and regression tests were passed with it. I have no further comments at this moment. I will make it "ready for c

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-04 Thread vignesh C
lot "test_slot" was not created in this database/? > $stderr =~ > /ERROR: publication "non_existent_pub" does not exist in the > publisher/, Modified. Thanks for the comments, Attached patch has the fixes for the same. Regards, Vignesh From c16bb01580c789bd0c09

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-04 Thread Bharath Rupireddy
On Mon, May 3, 2021 at 7:59 PM vignesh C wrote: > Thanks for the comments, these comments are handle in the v7 patch > posted in my earlier mail. Thanks. Some comments on v7 patch: 1) How about "Add publication names from the list to a string." instead of * Append the list of publication to de

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-03 Thread vignesh C
On Mon, May 3, 2021 at 11:11 AM Bharath Rupireddy wrote: > > On Sun, May 2, 2021 at 10:04 PM vignesh C wrote: > > > 5) Instead of adding a new file 021_validate_publications.pl for > > > tests, spawning a new test database which would make the overall > > > regression slower, can't we add with th

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-03 Thread vignesh C
Add a error case for connect=false and VALIDATE_PUBLICATION = true Added. Thanks for the comments, attached v7 patch has the fixes for the same. Thoughts? Regards, Vignesh From 09ae1cac60320bde08a6c380d3637eecdbb3d6ff Mon Sep 17 00:00:00 2001 From: vignesh Date: Wed, 7 Apr 2021 22:05:53 +0530

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-03 Thread Dilip Kumar
On Mon, May 3, 2021 at 10:48 AM Dilip Kumar wrote: > > On Sun, May 2, 2021 at 10:04 PM vignesh C wrote: > > > > Thanks for the comments. > > The Attached patch has the fixes for the same. > > I was reviewing the documentation part, I think in the below paragraph > we should include validate_publi

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-02 Thread Bharath Rupireddy
On Sun, May 2, 2021 at 10:04 PM vignesh C wrote: > > 5) Instead of adding a new file 021_validate_publications.pl for > > tests, spawning a new test database which would make the overall > > regression slower, can't we add with the existing database nodes in > > 0001_rep_changes.pl? I would sugges

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-02 Thread Dilip Kumar
On Sun, May 2, 2021 at 10:04 PM vignesh C wrote: > > Thanks for the comments. > The Attached patch has the fixes for the same. I was reviewing the documentation part, I think in the below paragraph we should include validate_publication as well? connect (boolean)

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-02 Thread vignesh C
I don't mind. 001_rep_changes.pl has the changes mainly for checking the replicated data. I did not find an appropriate file in the current tap tests, I preferred these tests to be in a separate file. Thoughts? Thanks for the comments. The Attached patch has the fixes for the same. Regards, Vign

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-01 Thread Bharath Rupireddy
On Sat, May 1, 2021 at 12:49 PM vignesh C wrote: > Thanks for the comments, Attached patch has the fixes for the same. > Thoughts? Few more comments on v5: 1) Deletion of below empty new line is spurious: - /* * Common option parsing function for CREATE and ALTER SUBSCRIPTION commands. * 2

Re: Identify missing publications from publisher while create/alter subscription.

2021-05-01 Thread vignesh C
ad the library providing us libpq calls. */ > + load_file("libpqwalreceiver", false); > + > +/* Try to connect to the publisher. */ > +wrconn = walrcv_connect(sub->conninfo, true, > sub->name, &err); > +

Re: Identify missing publications from publisher while create/alter subscription.

2021-04-13 Thread Bharath Rupireddy
On Tue, Apr 13, 2021 at 6:22 PM vignesh C wrote: > > 2) How about > > + Specifies whether the subscriber must verify the > > publications that are > > + being subscribed to are present in the publisher. By default, > > the subscriber > > instead of > > + Specifies whether t

Re: Identify missing publications from publisher while create/alter subscription.

2021-04-13 Thread vignesh C
tions); publications is an input list to this function, I did not want this function to change this list. I felt existing is fine. Thoughts? > 8) If you have done StringInfoData *cmd = makeStringInfo();, then no > need of initStringInfo(cmd); Modified. Attached v4 patch has the fixes for the co

Re: Identify missing publications from publisher while create/alter subscription.

2021-04-07 Thread Bharath Rupireddy
On Wed, Apr 7, 2021 at 10:37 PM vignesh C wrote: > > I think, we can also have validate_publication option allowed for > > ALTER SUBSCRIPTION SET PUBLICATION and REFRESH PUBLICATION commands > > with the same behaviour i.e. error out when specified publications > > don't exist in the publisher. Th

Re: Identify missing publications from publisher while create/alter subscription.

2021-04-07 Thread vignesh C
was working on a few other projects so I was not able to reply quickly. Since we are getting the opinion that if we make the check publications by default it might affect the existing users, I'm fine with having an option validate_option to check if the publication exists in the publisher, that way there is no cha

Re: Identify missing publications from publisher while create/alter subscription.

2021-03-03 Thread Bharath Rupireddy
On Wed, Mar 3, 2021 at 8:59 AM Euler Taveira wrote: > > On Wed, Feb 3, 2021, at 2:13 AM, Bharath Rupireddy wrote: > > On Mon, Jan 25, 2021 at 10:32 PM vignesh C wrote: > > > If a publication which does not exist is specified during create > > subscription, then we should throw an error similar t

Re: Identify missing publications from publisher while create/alter subscription.

2021-03-02 Thread Euler Taveira
On Wed, Feb 3, 2021, at 2:13 AM, Bharath Rupireddy wrote: > On Mon, Jan 25, 2021 at 10:32 PM vignesh C wrote: > > > If a publication which does not exist is specified during create > > subscription, then we should throw an error similar to step 2 behavior. > > Similarly if a publication which d

Re: Identify missing publications from publisher while create/alter subscription.

2021-02-02 Thread Bharath Rupireddy
On Mon, Jan 25, 2021 at 10:32 PM vignesh C wrote: > > I mean it doesn’t seem right to disallow to create the subscription if > > the publisher doesn't exist, and my reasoning was even though the > > publisher exists while creating the subscription you might drop it > > later right?. So basically,

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread japin
On Mon, 25 Jan 2021 at 21:55, Bharath Rupireddy wrote: > On Mon, Jan 25, 2021 at 5:18 PM japin wrote: >> > Do you mean when we drop publications from a subscription? If yes, do >> > we have a way to drop a publication from the subscription? See below >> > one of my earlier questions on this. >

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread vignesh C
On Mon, Jan 25, 2021 at 3:07 PM Dilip Kumar wrote: > > On Mon, Jan 25, 2021 at 2:48 PM Bharath Rupireddy > wrote: > > > > On Mon, Jan 25, 2021 at 2:42 PM Dilip Kumar wrote: > > > > > > On Mon, Jan 25, 2021 at 1:10 PM vignesh C wrote: > > > > > > > > On Thu, Jan 21, 2021 at 10:21 PM Bharath Rupi

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread vignesh C
On Mon, Jan 25, 2021 at 5:18 PM japin wrote: > > > On Mon, 25 Jan 2021 at 17:18, Bharath Rupireddy > wrote: > > On Mon, Jan 25, 2021 at 2:42 PM Dilip Kumar wrote: > >> > >> On Mon, Jan 25, 2021 at 1:10 PM vignesh C wrote: > >> > > >> > On Thu, Jan 21, 2021 at 10:21 PM Bharath Rupireddy > >> >

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread Bharath Rupireddy
On Mon, Jan 25, 2021 at 5:18 PM japin wrote: > > Do you mean when we drop publications from a subscription? If yes, do > > we have a way to drop a publication from the subscription? See below > > one of my earlier questions on this. > > "I wonder, why isn't dropping a publication from a list of >

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread japin
On Mon, 25 Jan 2021 at 17:18, Bharath Rupireddy wrote: > On Mon, Jan 25, 2021 at 2:42 PM Dilip Kumar wrote: >> >> On Mon, Jan 25, 2021 at 1:10 PM vignesh C wrote: >> > >> > On Thu, Jan 21, 2021 at 10:21 PM Bharath Rupireddy >> > wrote: >> > > >> > > On Thu, Jan 21, 2021 at 6:56 PM vignesh C

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread Dilip Kumar
On Mon, Jan 25, 2021 at 3:38 PM Bharath Rupireddy wrote: > > On Mon, Jan 25, 2021 at 3:07 PM Dilip Kumar wrote: > > > > So basically, the create subscription will throw an error if the > > > > publication does not exist. So will you throw an error if we try to > > > > drop the publication which

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread Bharath Rupireddy
On Mon, Jan 25, 2021 at 3:07 PM Dilip Kumar wrote: > > > So basically, the create subscription will throw an error if the > > > publication does not exist. So will you throw an error if we try to > > > drop the publication which is subscribed by some subscription? I mean > > > basically, you are

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread Dilip Kumar
On Mon, Jan 25, 2021 at 2:48 PM Bharath Rupireddy wrote: > > On Mon, Jan 25, 2021 at 2:42 PM Dilip Kumar wrote: > > > > On Mon, Jan 25, 2021 at 1:10 PM vignesh C wrote: > > > > > > On Thu, Jan 21, 2021 at 10:21 PM Bharath Rupireddy > > > wrote: > > > > > > > > On Thu, Jan 21, 2021 at 6:56 PM vi

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread Bharath Rupireddy
On Mon, Jan 25, 2021 at 2:42 PM Dilip Kumar wrote: > > On Mon, Jan 25, 2021 at 1:10 PM vignesh C wrote: > > > > On Thu, Jan 21, 2021 at 10:21 PM Bharath Rupireddy > > wrote: > > > > > > On Thu, Jan 21, 2021 at 6:56 PM vignesh C wrote: > > > > > > > > Hi, > > > > > > > > Creating/altering subscr

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-25 Thread Dilip Kumar
On Mon, Jan 25, 2021 at 1:10 PM vignesh C wrote: > > On Thu, Jan 21, 2021 at 10:21 PM Bharath Rupireddy > wrote: > > > > On Thu, Jan 21, 2021 at 6:56 PM vignesh C wrote: > > > > > > Hi, > > > > > > Creating/altering subscription is successful when we specify a > > > publication which does not ex

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-24 Thread vignesh C
scription set publication. Thoughts? Regards, Vignesh EnterpriseDB: http://www.enterprisedb.com From 6ef5a35d82065ec7e497ebe38e575afa45ad9469 Mon Sep 17 00:00:00 2001 From: Vignesh C Date: Thu, 21 Jan 2021 18:38:54 +0530 Subject: [PATCH v2] Identify missing publications from publisher while creat

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-22 Thread vignesh C
On Fri, Jan 22, 2021 at 10:14 AM japin wrote: > > > On Fri, 22 Jan 2021 at 00:51, Bharath Rupireddy > wrote: > > On Thu, Jan 21, 2021 at 6:56 PM vignesh C wrote: > >> > >> Hi, > >> > >> Creating/altering subscription is successful when we specify a > >> publication which does not exist in the p

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-22 Thread vignesh C
On Fri, Jan 22, 2021 at 12:14 PM Bharath Rupireddy wrote: > > On Fri, Jan 22, 2021 at 10:14 AM japin wrote: > > > 2) Can't we know whether the publications exist on the publisher with > > > the existing (or modifying it a bit if required) query in > > > fetch_table_list(), so that we can avoid ma

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-21 Thread Bharath Rupireddy
On Fri, Jan 22, 2021 at 10:14 AM japin wrote: > > 2) Can't we know whether the publications exist on the publisher with > > the existing (or modifying it a bit if required) query in > > fetch_table_list(), so that we can avoid making another connection to > > the publisher system from the subscrib

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-21 Thread japin
On Fri, 22 Jan 2021 at 00:51, Bharath Rupireddy wrote: > On Thu, Jan 21, 2021 at 6:56 PM vignesh C wrote: >> >> Hi, >> >> Creating/altering subscription is successful when we specify a >> publication which does not exist in the publisher. I felt we should >> throw an error in this case, that w

Re: Identify missing publications from publisher while create/alter subscription.

2021-01-21 Thread Bharath Rupireddy
On Thu, Jan 21, 2021 at 6:56 PM vignesh C wrote: > > Hi, > > Creating/altering subscription is successful when we specify a > publication which does not exist in the publisher. I felt we should > throw an error in this case, that will help the user to check if there > is any typo in the create sub

Identify missing publications from publisher while create/alter subscription.

2021-01-21 Thread vignesh C
From 2e7a6e41f789f7f1717058e9c78441ae8d5faf9e Mon Sep 17 00:00:00 2001 From: Vignesh C Date: Thu, 21 Jan 2021 18:38:54 +0530 Subject: [PATCH v1] Identify missing publications from publisher while create/alter subscription. Creating/altering subscription is successful when we specify a publication