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
On Tue, Mar 29, 2022 at 11:02 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-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
On Tue, Mar 22, 2022 at 3:23 PM vignesh C wrote: > > On Tue, Mar 22, 2022 at 5:29 AM Andres Freund wrote: > > > > 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 currentl

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

2022-03-22 Thread vignesh C
On Tue, Mar 22, 2022 at 5:29 AM Andres Freund wrote: > > 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 Th

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
On Fri, Feb 11, 2022 at 7:14 PM Ashutosh Sharma wrote: > > 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. > > >

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 Wed, Nov 10, 2021 at 11:16 AM Bharath Rupireddy wrote: > > 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 > ER

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
On Tue, Sep 28, 2021 at 7:49 AM Jaime Casanova wrote: > > 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:

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
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: > > > > > > > > On Fri, May 7, 2021 at 6:44 PM vignesh C wrote: > > > > > >

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

2021-07-15 Thread vignesh C
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: > > > > > > On Fri, May 7, 2021 at 6:44 PM vignesh C wrote: > > > > > > > > Thanks for the comments, the attached patch has the fix for t

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

2021-07-06 Thread vignesh C
On Wed, Jun 30, 2021 at 8:23 PM vignesh C wrote: > > On Sun, Jun 6, 2021 at 11:55 AM vignesh C wrote: > > > > On Fri, May 7, 2021 at 6:44 PM vignesh C wrote: > > > > > > Thanks for the comments, the attached patch has the fix for the same. > > > > The patch was not applying on the head, attached

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

2021-06-30 Thread vignesh C
On Sun, Jun 6, 2021 at 11:55 AM vignesh C wrote: > > On Fri, May 7, 2021 at 6:44 PM vignesh C wrote: > > > > Thanks for the comments, the attached patch has the fix for the same. > > The patch was not applying on the head, attached patch which is rebased on > HEAD. The patch was not applying on

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

2021-06-05 Thread vignesh C
On Fri, May 7, 2021 at 6:44 PM vignesh C wrote: > > On Fri, May 7, 2021 at 5:44 PM Dilip Kumar wrote: > > > > 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 wrot

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

2021-05-07 Thread vignesh C
On Fri, May 7, 2021 at 5:44 PM Dilip Kumar wrote: > > 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 an

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
On Thu, May 6, 2021 at 9:08 AM Japin Li wrote: > > > 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

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
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 on v7 patch: > > 1) How about "Add publication names from the

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
On Mon, May 3, 2021 at 1:46 PM Dilip Kumar wrote: > > 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 pa

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
On Sat, May 1, 2021 at 7:58 PM Bharath Rupireddy wrote: > > 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: > - > /* > * Comm

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
On Tue, Apr 13, 2021 at 8:01 PM Bharath Rupireddy wrote: > > 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

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
On Thu, Apr 8, 2021 at 12:13 PM Bharath Rupireddy wrote: > > 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

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
On Thu, Mar 4, 2021 at 1:04 PM Bharath Rupireddy wrote: > > 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

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
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 exist in the publisher. I felt we should > > throw an error in this case

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