Re: Handle infinite recursion in logical replication setup

2022-09-02 Thread vignesh C
On Mon, 29 Aug 2022 at 16:35, Amit Kapila wrote: > > On Wed, Aug 24, 2022 at 7:27 PM vignesh C wrote: > > > > Since there was no objections to change it to throw a warning, I have > > made the changes for the same. > > > > Review comments for v42-0001* >

Re: Handle infinite recursion in logical replication setup

2022-09-01 Thread vignesh C
On Thu, 1 Sept 2022 at 09:19, Amit Kapila wrote: > > On Wed, Aug 31, 2022 at 11:35 AM Peter Smith wrote: > > > > Here are my review comments for v43-0001. > > > > == > > > > 1. Commit message > > > > The initial copy phase has no way to know the origin of the row data, > > so if 'copy_data =

Re: Handle infinite recursion in logical replication setup

2022-09-01 Thread vignesh C
On Thu, 1 Sept 2022 at 08:01, shiy.f...@fujitsu.com wrote: > > On Wed, Aug 31, 2022 1:06 AM vignesh C wrote: > > > > The attached v43 patch has the changes for the same. > > > > Thanks for updating the patch. > > Here is a comment on the 0001 patch.

Re: Handle infinite recursion in logical replication setup

2022-09-01 Thread vignesh C
On Wed, 31 Aug 2022 at 11:45, Peter Smith wrote: > > Here are some review comments for patch v43-0002: > > == > > 1. doc/src/sgml/ref/create_subscription.sgml > > @@ -403,7 +403,9 @@ CREATE SUBSCRIPTION class="parameter">subscription_name warning to notify the user to check the publisher

Re: Handle infinite recursion in logical replication setup

2022-09-01 Thread vignesh C
On Mon, 29 Aug 2022 at 16:35, Amit Kapila wrote: > > On Wed, Aug 24, 2022 at 7:27 PM vignesh C wrote: > > > > Since there was no objections to change it to throw a warning, I have > > made the changes for the same. > > > > Review comments for v42-0001* >

Re: Handle infinite recursion in logical replication setup

2022-09-01 Thread vignesh C
On Wed, 31 Aug 2022 at 11:35, Peter Smith wrote: > > Here are my review comments for v43-0001. > > == > > 1. Commit message > > The initial copy phase has no way to know the origin of the row data, > so if 'copy_data = true' in the step 4 below, log a warning to notify user > that potentially

Re: Handle infinite recursion in logical replication setup

2022-08-30 Thread vignesh C
On Mon, 29 Aug 2022 at 12:01, Peter Smith wrote: > > Here are some review comments for patch v42-0002: > > == > > 1. doc/src/sgml/logical-replication.sgml > > copy_data = true > > There are a couple of these tags where there is a trailing space > before the . I guess it is doing no harm, but

Re: Handle infinite recursion in logical replication setup

2022-08-30 Thread vignesh C
On Mon, 29 Aug 2022 at 11:59, Peter Smith wrote: > > Here are some review comments for patch v42-0001: > > == > > 1. Commit message > > A later review comment below suggests some changes to the WARNING > message so if those changes are made then the example in this commit > message also needs

Re: Handle infinite recursion in logical replication setup

2022-08-28 Thread vignesh C
On Fri, Aug 26, 2022 at 9:52 AM Dilip Kumar wrote: > > On Mon, Aug 22, 2022 at 9:19 AM houzj.f...@fujitsu.com > wrote: > > > > > Jonathan, Sawada-San, Hou-San, and others, what do you think is the best > > > way > > > to move forward here? > > > > I think it's fine to throw a WARNING in this cas

Re: Column Filtering in Logical Replication

2022-08-25 Thread vignesh C
On Tue, Aug 23, 2022 at 7:52 AM Peter Smith wrote: > > On Mon, Aug 22, 2022 at 9:25 PM vignesh C wrote: > > > ... > > > Few comments: > > 1) I felt no expressions are allowed in case of column filters. Only > > column names can be specified. The second part

Re: Handle infinite recursion in logical replication setup

2022-08-24 Thread vignesh C
On Mon, Aug 22, 2022 at 9:19 AM houzj.f...@fujitsu.com wrote: > > On Thursday, August 18, 2022 11:13 AM Amit Kapila > wrote: > > > > On Wed, Aug 17, 2022 at 12:34 PM Peter Smith > > wrote: > > > > > > On Wed, Aug 17, 2022 at 4:33 PM Amit Kapila > > wrote: > > > > > > > > On Wed, Aug 17, 2022 a

Re: Include the dependent extension information in describe command.

2022-08-22 Thread vignesh C
On Tue, Aug 16, 2022 at 9:04 PM Bruce Momjian wrote: > > On Mon, Aug 15, 2022 at 10:09:29PM +0530, vignesh C wrote: > > I have updated the patch to display "Objects depending on extension" > > as describe extension footer. The changes for the same are available

Re: Column Filtering in Logical Replication

2022-08-22 Thread vignesh C
On Mon, Aug 22, 2022 at 1:58 PM Peter Smith wrote: > > Thanks for the view of v1-0001. > > On Wed, Aug 17, 2022 at 3:04 AM vignesh C wrote: > ... > > 1) Row filters mentions that "It has no effect on TRUNCATE commands.", > > the same is not present in case

Re: Skipping schema changes in publication

2022-08-18 Thread vignesh C
On Mon, Aug 8, 2022 at 2:53 PM vignesh C wrote: > > On Mon, Aug 8, 2022 at 12:46 PM vignesh C wrote: > > > > On Fri, Jun 3, 2022 at 3:36 PM vignesh C wrote: > > > > > > On Thu, May 26, 2022 at 7:04 PM osumi.takami...@fujitsu.com > > > wrote: &g

Re: Skipping schema changes in publication

2022-08-18 Thread vignesh C
On Thu, Aug 18, 2022 at 12:33 PM Nitin Jadhav wrote: > > I spent some time on understanding the proposal and the patch. Here > are a few comments wrt the test cases. > > > +ALTER PUBLICATION testpub_reset ADD TABLE pub_sch1.tbl1; > > + > > +-- Verify that tables associated with the publication are

Re: Column Filtering in Logical Replication

2022-08-16 Thread vignesh C
On Mon, Aug 8, 2022 at 2:08 PM Peter Smith wrote: > > PSA patch version v1* for a new "Column Lists" pgdocs section > > This is just a first draft, but I wanted to post it as-is, with the > hope that I can get some feedback while continuing to work on it. Few comments: 1) Row filters mentions tha

Re: Include the dependent extension information in describe command.

2022-08-15 Thread vignesh C
On Sun, Aug 14, 2022 at 10:24 PM vignesh C wrote: > > On Sun, Aug 14, 2022 at 11:07 AM Tom Lane wrote: > > > > vignesh C writes: > > > Currently we do not include the dependent extension information for > > > index and materialized view in the describe comm

Re: Tab completion for "ALTER TYPE typename SET" and rearranged "Alter TYPE typename RENAME"

2022-08-15 Thread vignesh C
On Mon, Aug 15, 2022 at 10:42 AM Michael Paquier wrote: > > On Sun, Aug 14, 2022 at 07:56:00PM +0530, vignesh C wrote: > > Modified the patch to list all the properties in case of "ALTER TYPE > > typename SET (". I have included the properties in alphabetical or

Re: Include the dependent extension information in describe command.

2022-08-14 Thread vignesh C
On Sun, Aug 14, 2022 at 11:07 AM Tom Lane wrote: > > vignesh C writes: > > Currently we do not include the dependent extension information for > > index and materialized view in the describe command. I felt it would > > be useful to include this information as part

Re: Tab completion for "ALTER TYPE typename SET" and rearranged "Alter TYPE typename RENAME"

2022-08-14 Thread vignesh C
On Sun, Aug 14, 2022 at 3:41 PM Michael Paquier wrote: > > On Sun, Aug 14, 2022 at 08:25:01AM +0530, vignesh C wrote: > > Attached patch has the changes for the same. Thoughts? > > > > a) Add tab completion for "ALTER TYPE typename SET" was missing. > > Wh

Tab completion for "ALTER TYPE typename SET" and rearranged "Alter TYPE typename RENAME"

2022-08-13 Thread vignesh C
Hi, This patch does a couple of things: a) Tab completion for "ALTER TYPE typename SET" was missing. Added tab completion for the same. b) Tab completion for "ALTER TYPE RENAME VALUE" was not along with tab completion of "ALTER TYPE" commands, it was present after "ALTER GROUP ", rearranged "ALTE

Include the dependent extension information in describe command.

2022-08-13 Thread vignesh C
Hi, Currently we do not include the dependent extension information for index and materialized view in the describe command. I felt it would be useful to include this information as part of the describe command like: \d+ idx_depends Index "public.idx_depends" Column | Type |

Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock

2022-08-11 Thread vignesh C
On Wed, Aug 10, 2022 at 2:52 PM Amit Kapila wrote: > > On Wed, Aug 10, 2022 at 10:58 AM Andres Freund wrote: > > > > Hi, > > > > On 2022-08-09 20:21:19 -0700, Mark Dilger wrote: > > > > On Aug 9, 2022, at 7:26 PM, Andres Freund wrote: > > > > > > > > The relevant code triggering it: > > > > > >

Re: Skipping schema changes in publication

2022-08-08 Thread vignesh C
On Mon, Aug 8, 2022 at 12:46 PM vignesh C wrote: > > On Fri, Jun 3, 2022 at 3:36 PM vignesh C wrote: > > > > On Thu, May 26, 2022 at 7:04 PM osumi.takami...@fujitsu.com > > wrote: > > > > > > On Monday, May 23, 2022 2:13 PM vignesh C wrote: > >

Re: Skipping schema changes in publication

2022-08-08 Thread vignesh C
On Fri, Jun 3, 2022 at 3:36 PM vignesh C wrote: > > On Thu, May 26, 2022 at 7:04 PM osumi.takami...@fujitsu.com > wrote: > > > > On Monday, May 23, 2022 2:13 PM vignesh C wrote: > > > Attached v7 patch which fixes the buildfarm warning for an unused warning >

Re: Logical replication - schema change not invalidating the relation cache

2022-08-07 Thread vignesh C
On Sat, Mar 12, 2022 at 1:29 PM vignesh C wrote: > > On Fri, Dec 3, 2021 at 3:21 PM vignesh C wrote: > > > > On Fri, Dec 3, 2021 at 1:13 PM Michael Paquier wrote: > > > > > > On Thu, Aug 26, 2021 at 09:00:39PM +0530, vignesh C wrote: > > > > The

Re: Handle infinite recursion in logical replication setup

2022-08-07 Thread vignesh C
On Fri, Jul 29, 2022 at 10:51 AM vignesh C wrote: > > On Fri, Jul 29, 2022 at 8:31 AM Peter Smith wrote: > > > > Here are some comments for the patch v40-0001: > > > > == > > > > 1. Commit message > > > > It might be better to always u

Re: making relfilenodes 56 bits

2022-07-29 Thread vignesh C
On Wed, Jul 27, 2022 at 6:02 PM Dilip Kumar wrote: > > On Wed, Jul 27, 2022 at 3:27 PM vignesh C wrote: > > > > > Thanks for the updated patch, Few comments: > > 1) The format specifier should be changed from %u to INT64_FORMAT > > autoprewarm.c -> apw_loa

Re: Handle infinite recursion in logical replication setup

2022-07-28 Thread vignesh C
nt to node2. This process of node1 sending data to node2 and node2 sending data to node1 will repeat infinitely. If table t1 has a unique key, this will lead to a unique key violation and replication won't proceed. This problem can be avoided by using origin and copy_data parameters as g

Re: Handle infinite recursion in logical replication setup

2022-07-28 Thread vignesh C
x27;copy_data = force' when creating a subscription to node1 so that the existing table data is copied during initial sync: node2=# CREATE SUBSCRIPTION sub_node2_node1 CONNECTION '' node2-# PUBLICATION pub_node1 WITH (copy_data = force, origin = none); CREATE SUBSCRIPTION Author: Vign

Re: Handle infinite recursion in logical replication setup

2022-07-28 Thread vignesh C
On Thu, Jul 28, 2022 at 11:28 AM Peter Smith wrote: > > Hi Vignesh. > > FYI the v39* patch fails to apply [1]. Can you please rebase it? > > > [1] > === Applying patches on top of PostgreSQL commit ID > 5f858dd3bebd1f3845aef2bff7f4345bfb7b74b3 === > === applying patch > ./v39-0001-Check-and-throw-

Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.

2022-07-27 Thread vignesh C
On Wed, Jul 27, 2022 at 4:22 PM Michael Paquier wrote: > > On Wed, Jul 27, 2022 at 08:47:46AM +0530, vignesh C wrote: > > I feel this would be an overkill, I did not make any changes for this. > > Agreed. Using an extra layer of wrappers for that seems a bit too > much, so I

Re: making relfilenodes 56 bits

2022-07-27 Thread vignesh C
On Tue, Jul 26, 2022 at 1:32 PM Dilip Kumar wrote: > > On Thu, Jul 21, 2022 at 9:53 AM Thomas Munro wrote: > > > > On Wed, Jul 20, 2022 at 11:27 PM Dilip Kumar wrote: > > > [v10 patch set] > > > > Hi Dilip, I'm experimenting with these patches and will hopefully have > > more to say soon, but I

Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.

2022-07-26 Thread vignesh C
On Mon, Jul 25, 2022 at 10:22 AM Amit Kapila wrote: > > On Mon, Jul 25, 2022 at 8:34 AM Peter Smith wrote: > > > > On Mon, Jul 25, 2022 at 11:08 AM Michael Paquier > > wrote: > > > > > > On Sun, Jul 24, 2022 at 09:52:16PM +0530, vignesh C wrote

Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.

2022-07-26 Thread vignesh C
On Mon, Jul 25, 2022 at 8:34 AM Peter Smith wrote: > > On Mon, Jul 25, 2022 at 11:08 AM Michael Paquier wrote: > > > > On Sun, Jul 24, 2022 at 09:52:16PM +0530, vignesh C wrote: > > > Thanks for the comments, i have modified it by changing it to a > > > bool

Re: Handle infinite recursion in logical replication setup

2022-07-26 Thread vignesh C
On Mon, Jul 25, 2022 at 12:58 PM Peter Smith wrote: > > Firstly, I have some (case-sensitivity) questions about the previous > patch which was already pushed [1]. > > Q1. create_subscription docs > > I did not understand why the docs refer to slot_name = NONE, yet the > newly added option says ori

Re: Handle infinite recursion in logical replication setup

2022-07-26 Thread vignesh C
On Tue, Jul 26, 2022 at 2:12 PM wangw.f...@fujitsu.com wrote: > > On Sun, Jul 24, 2022 1:28 AM vignesh C wrote: > > Added a note for the same and referred it to the conflicts section. > > > > Thanks for the comments, the attached v38 patch has the changes for the >

Re: Handle infinite recursion in logical replication setup

2022-07-26 Thread vignesh C
On Tue, Jul 26, 2022 at 1:35 PM shiy.f...@fujitsu.com wrote: > > On Sun, Jul 24, 2022 1:28 AM vignesh C wrote: > > > > Added a note for the same and referred it to the conflicts section. > > > > Thanks for the comments, the attached v38 patch has the changes for th

Re: Handle infinite recursion in logical replication setup

2022-07-26 Thread vignesh C
On Tue, Jul 26, 2022 at 7:16 AM Peter Smith wrote: > > Here are some review comments for the patch v38-0002: > > == > > - terminology > > There seemed to be an inconsistent alternation of the terms > "primaries" and "nodes"... For example "Setting replication between > two primaries" versus "

Re: Handle infinite recursion in logical replication setup

2022-07-26 Thread vignesh C
N After the subscription is created on node2, node1 will be synced to node2 and the newly synced data will be sent to node2. This process of node1 sending data to node2 and node2 sending data to node1 will repeat infinitely. If table t1 has a unique key, this will lead to a unique key vi

Re: Handle infinite recursion in logical replication setup

2022-07-25 Thread vignesh C
On Mon, Jul 25, 2022 at 2:24 PM vignesh C wrote: > > On Sun, Jul 24, 2022 at 10:21 PM Jonathan S. Katz > wrote: > > > > On 7/22/22 12:47 AM, Amit Kapila wrote: > > > On Fri, Jul 22, 2022 at 1:39 AM Jonathan S. Katz > > > wrote: > > > >

Re: Handle infinite recursion in logical replication setup

2022-07-25 Thread vignesh C
On Mon, Jul 25, 2022 at 12:58 PM Peter Smith wrote: > > Firstly, I have some (case-sensitivity) questions about the previous > patch which was already pushed [1]. > > Q1. create_subscription docs > > I did not understand why the docs refer to slot_name = NONE, yet the > newly added option says ori

Re: Handle infinite recursion in logical replication setup

2022-07-25 Thread vignesh C
On Sun, Jul 24, 2022 at 10:21 PM Jonathan S. Katz wrote: > > On 7/22/22 12:47 AM, Amit Kapila wrote: > > On Fri, Jul 22, 2022 at 1:39 AM Jonathan S. Katz > > wrote: > > >> 1. I'm concerned by calling this "Bidirectional replication" in the docs > >> that we are overstating the current capabiliti

Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.

2022-07-24 Thread vignesh C
ke use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations. Most of the code is common between GetSubscriptionRelations and GetSubscriptionNotReadyRelations. Added a parameter to GetSubscriptionRelations which could provide the same functionality for GetSubscriptionRelations

Re: Handle infinite recursion in logical replication setup

2022-07-23 Thread vignesh C
On Fri, Jul 22, 2022 at 10:17 AM Amit Kapila wrote: > > On Fri, Jul 22, 2022 at 1:39 AM Jonathan S. Katz wrote: > > > > Thanks for the work on this feature -- this is definitely very helpful > > towards supporting more types of use cases with logical replication! > > > > I've read through the pro

Re: Handle infinite recursion in logical replication setup

2022-07-23 Thread vignesh C
On Fri, Jul 22, 2022 at 1:39 AM Jonathan S. Katz wrote: > > Hi, > > On 7/21/22 6:34 AM, vignesh C wrote: > > On Thu, Jul 21, 2022 at 2:06 PM Amit Kapila wrote: > >> > >> On Wed, Jul 20, 2022 at 2:33 PM vignesh C wrote: > >>> > >>> Modi

Re: making relfilenodes 56 bits

2022-07-22 Thread vignesh C
On Wed, Jul 20, 2022 at 4:57 PM Dilip Kumar wrote: > > On Mon, Jul 18, 2022 at 4:51 PM Dilip Kumar wrote: > > > > I was doing some more testing by setting the FirstNormalRelFileNumber > > to a high value(more than 32 bits) I have noticed a couple of problems > > there e.g. relpath is still using

Re: Handle infinite recursion in logical replication setup

2022-07-21 Thread vignesh C
On Thu, Jul 21, 2022 at 2:06 PM Amit Kapila wrote: > > On Wed, Jul 20, 2022 at 2:33 PM vignesh C wrote: > > > > Modified. Apart from this I have run pgperltidy on the perl file and > > renamed 032_origin.pl to 030_origin.pl as currently there is > > 029_on_error.pl

Re: Handle infinite recursion in logical replication setup

2022-07-20 Thread vignesh C
On Wed, Jul 20, 2022 at 10:38 AM Peter Smith wrote: > > On Tue, Jul 19, 2022 at 11:34 PM Amit Kapila wrote: > > > > On Mon, Jul 18, 2022 at 9:46 PM vignesh C wrote: > > > > > > I have updated the patch to handle the origin value case > > > insensit

Re: Handle infinite recursion in logical replication setup

2022-07-15 Thread vignesh C
On Thu, Jul 14, 2022 at 6:42 PM Dilip Kumar wrote: > > On Thu, 14 Jul 2022 at 6:34 PM, vignesh C wrote: >> >> On Thu, Jul 14, 2022 at 11:26 AM Dilip Kumar wrote: >> > >> > On Wed, Jul 13, 2022 at 4:49 PM Dilip Kumar wrote: >> > > >>

Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.

2022-07-14 Thread vignesh C
On Thu, Jul 14, 2022 at 4:34 AM Peter Smith wrote: > > On Wed, Jul 13, 2022 at 7:55 PM vignesh C wrote: > > > > On Wed, Jul 13, 2022 at 1:13 PM Michael Paquier wrote: > > > > > > On Wed, Jul 13, 2022 at 12:22:06PM +0530, vignesh C wrote: > &

Re: Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.

2022-07-13 Thread vignesh C
On Wed, Jul 13, 2022 at 1:13 PM Michael Paquier wrote: > > On Wed, Jul 13, 2022 at 12:22:06PM +0530, vignesh C wrote: > > Most of the code is common between GetSubscriptionRelations and > > GetSubscriptionNotReadyRelations. Added a parameter to > > GetSubscriptionRelations

Refactor to make use of a common function for GetSubscriptionRelations and GetSubscriptionNotReadyRelations.

2022-07-12 Thread vignesh C
Hi, Most of the code is common between GetSubscriptionRelations and GetSubscriptionNotReadyRelations. Added a parameter to GetSubscriptionRelations which could provide the same functionality as the existing GetSubscriptionRelations and GetSubscriptionNotReadyRelations. Attached patch has the chang

Re: Handle infinite recursion in logical replication setup

2022-07-11 Thread vignesh C
On Mon, Jul 11, 2022 at 5:03 PM Amit Kapila wrote: > > On Sat, Jul 9, 2022 at 8:11 PM vignesh C wrote: > > > > Thanks, a few more comments on v30_0002* > 1. > +/* > + * Represents whether copy_data parameter is specified with off, on or force. > > A comma is

Re: explain analyze rows=%.0f

2022-07-07 Thread vignesh C
On Thu, Jun 23, 2022 at 2:25 AM Ibrar Ahmed wrote: > > > > On Thu, Jun 23, 2022 at 1:04 AM David G. Johnston > wrote: >> >> On Wed, Jun 22, 2022 at 12:11 PM Ibrar Ahmed wrote: >>> >>> On Thu, Jun 23, 2022 at 12:01 AM Tom Lane wrote: Robert Haas writes: > On Jun 2, 2009, at 9:41

Re: Handle infinite recursion in logical replication setup

2022-07-05 Thread vignesh C
On Tue, Jul 5, 2022 at 6:14 AM Peter Smith wrote: > > I checked again the v26* patch set. > > I had no more comments for v26-0001, v26-0002, or v26-0004, but below > are some comments for v26-0003. > > > v26-0003 > > > 3.1 src/backend/catalog/pg_subscription.c > > 3.1.a > +/* > +

Re: Handle infinite recursion in logical replication setup

2022-07-04 Thread vignesh C
On Mon, Jul 4, 2022 at 7:44 PM Alvaro Herrera wrote: > > > From d8f8844f877806527b6f3f45320b6ba55a8e3154 Mon Sep 17 00:00:00 2001 > > From: Vigneshwaran C > > Date: Thu, 26 May 2022 19:29:33 +0530 > > Subject: [PATCH v27 1/4] Add a missing test to verify only-local parameter > > in > > test_dec

Re: Handle infinite recursion in logical replication setup

2022-07-04 Thread vignesh C
On Mon, Jul 4, 2022 at 9:23 AM Amit Kapila wrote: > > On Mon, Jul 4, 2022 at 3:59 AM Peter Smith wrote: > > > > On Mon, Jul 4, 2022 at 12:59 AM vignesh C wrote: > > ... > > > > 2. > > > > /* ALTER SUBSCRIPTION SET ( */ > > > &

Re: Handle infinite recursion in logical replication setup

2022-07-04 Thread vignesh C
On Mon, Jul 4, 2022 at 1:46 PM shiy.f...@fujitsu.com wrote: > > On Sun, Jul 3, 2022 11:00 PM vignesh C wrote: > > > > Thanks for the comments, the attached v27 patch has the changes for the > > same. > > > > Thanks for updating th

Re: Support logical replication of DDLs

2022-07-02 Thread vignesh C
On Sat, Jul 2, 2022 at 8:51 AM Amit Kapila wrote: > > On Fri, Jul 1, 2022 at 10:22 PM vignesh C wrote: > > > > On Wed, Jun 29, 2022 at 3:25 PM houzj.f...@fujitsu.com > > wrote: > > > > > > > Thanks for the updated patch. > > Few comments on 000

Re: Support logical replication of DDLs

2022-07-01 Thread vignesh C
On Wed, Jun 29, 2022 at 3:25 PM houzj.f...@fujitsu.com wrote: > > On Wednesday, June 29, 2022 11:07 AM Amit Kapila > wrote: > > > > On Tue, Jun 28, 2022 at 5:43 PM Amit Kapila > > wrote: > > > > > > 5. > > > +static ObjTree * > > > +deparse_CreateStmt(Oid objectId, Node *parsetree) > > > { > >

Re: Support logical replication of DDLs

2022-06-28 Thread vignesh C
On Tue, Jun 21, 2022 at 5:49 PM houzj.f...@fujitsu.com wrote: > > On Monday, June 20, 2022 11:32 AM houzj.f...@fujitsu.com > wrote: > > > > On Saturday, June 18, 2022 3:38 AM Zheng Li wrote: > > > On Wed, Jun 15, 2022 at 12:00 AM Amit Kapila > > > wrote: > > > > > > > > On Wed, Jun 15, 2022 at

Re: Handle infinite recursion in logical replication setup

2022-06-23 Thread vignesh C
On Thu, Jun 23, 2022 at 7:05 AM shiy.f...@fujitsu.com wrote: > > On Mon, Jun 20, 2022 7:55 PM vignesh C wrote: > > > > Thanks for the comment, the v22 patch attached has the changes for the > > same. > > Thanks for updating the patch, here are some comments on 00

Re: Support logical replication of DDLs

2022-06-22 Thread vignesh C
On Tue, Jun 21, 2022 at 5:49 PM houzj.f...@fujitsu.com wrote: > > On Monday, June 20, 2022 11:32 AM houzj.f...@fujitsu.com > wrote: > > > > On Saturday, June 18, 2022 3:38 AM Zheng Li wrote: > > > On Wed, Jun 15, 2022 at 12:00 AM Amit Kapila > > > wrote: > > > > > > > > On Wed, Jun 15, 2022 at

Re: Handle infinite recursion in logical replication setup

2022-06-20 Thread vignesh C
On Mon, Jun 20, 2022 at 3:16 PM vignesh C wrote: > > On Mon, Jun 20, 2022 at 2:37 PM Dilip Kumar wrote: > > > > On Thu, Jun 16, 2022 at 3:48 PM vignesh C wrote: > > > > > > On Wed, Jun 15, 2022 at 12:09 PM Peter Smith > > > wrote: > > >

Re: Handle infinite recursion in logical replication setup

2022-06-20 Thread vignesh C
On Mon, Jun 20, 2022 at 2:37 PM Dilip Kumar wrote: > > On Thu, Jun 16, 2022 at 3:48 PM vignesh C wrote: > > > > On Wed, Jun 15, 2022 at 12:09 PM Peter Smith wrote: > > > > > > Thanks for the comments, the attached v21 patch has the changes for the > >

Re: Handle infinite recursion in logical replication setup

2022-06-16 Thread vignesh C
On Wed, Jun 15, 2022 at 12:13 PM Peter Smith wrote: > > Here are some review comments for patch v20-0004. > > == > > 1. General > > I thought that it is better to refer to the > subscription/publications/table "on" the node, rather than "in" the > node. Most of the review comments below are re

Re: Handle infinite recursion in logical replication setup

2022-06-16 Thread vignesh C
On Wed, Jun 15, 2022 at 12:11 PM Peter Smith wrote: > > Here are some review comments for patch v20-0003. > > == > > 1. Commit message > > In case, table t1 has a unique key, it will lead to a unique key > violation and replication won't proceed. > > SUGGESTION > If table t1 has a unique key,

Re: Handle infinite recursion in logical replication setup

2022-06-14 Thread vignesh C
On Fri, Jun 10, 2022 at 2:09 PM Peter Smith wrote: > > Below are some review comments for the patch v18-0004 > > == > > 1. Commit message > > Document the steps for the following: > a) Create a two-node bidirectional replication when there is no data in both > the > nodes. > b) Adding a new n

Re: Handle infinite recursion in logical replication setup

2022-06-05 Thread vignesh C
On Fri, Jun 3, 2022 at 11:01 AM Peter Smith wrote: > > Please find below my review comments for patch v17-0002: > > == > > 1. Commit message > > This patch adds a new SUBSCRIPTION parameter "origin". It Specifies whether > the subscription will request the publisher to only send changes that >

Re: Skipping schema changes in publication

2022-06-03 Thread vignesh C
On Tue, May 31, 2022 at 11:51 AM Peter Smith wrote: > > Here are my review comments for patch v7-0002. > > == > > 1. doc/src/sgml/logical-replication.sgml > > @@ -1167,8 +1167,9 @@ CONTEXT: processing remote data for replication > origin "pg_16395" during "INSER > > To add tables to a

Re: Skipping schema changes in publication

2022-06-03 Thread vignesh C
'On Mon, May 30, 2022 at 1:51 PM Peter Smith wrote: > > Here are some minor review comments for v7-0001. > > == > > 1. General > > Probably the commit message and all the PG docs and code comments > should be changed to refer to "publication parameters" instead of > (currently) "publication op

Re: Skipping schema changes in publication

2022-06-03 Thread vignesh C
On Thu, May 26, 2022 at 7:04 PM osumi.takami...@fujitsu.com wrote: > > On Monday, May 23, 2022 2:13 PM vignesh C wrote: > > Attached v7 patch which fixes the buildfarm warning for an unused warning in > > release mode as in [1]. > Hi, thank you for the patches. > >

Re: Handle infinite recursion in logical replication setup

2022-06-01 Thread vignesh C
On Fri, May 27, 2022 at 2:08 PM Peter Smith wrote: > > On Fri, May 27, 2022 at 5:04 PM shiy.f...@fujitsu.com > wrote: > > > > On Wed, May 25, 2022 7:55 PM vignesh C wrote: > > > > > > The attached v16 patch has the changes for the same. > > > >

Re: Handle infinite recursion in logical replication setup

2022-06-01 Thread vignesh C
On Fri, May 27, 2022 at 12:34 PM shiy.f...@fujitsu.com wrote: > > On Wed, May 25, 2022 7:55 PM vignesh C wrote: > > > > The attached v16 patch has the changes for the same. > > > > Thanks for updating the patch. > > Some comments for the document in 0002

Re: Handle infinite recursion in logical replication setup

2022-06-01 Thread vignesh C
On Fri, May 27, 2022 at 10:56 AM Peter Smith wrote: > > Here are some more review comments for v15-0002 I found while working > through the documented examples. These are all for > doc/src/sgml/logical-replication.sgml. The section numbers (e.g. > 31.11.1) are the assigned numbers after HTML rende

Re: Handle infinite recursion in logical replication setup

2022-06-01 Thread vignesh C
On Fri, May 27, 2022 at 7:54 AM Amit Kapila wrote: > > On Wed, Apr 6, 2022 at 9:36 AM Amit Kapila wrote: > > > > On Tue, Apr 5, 2022 at 7:06 PM Ashutosh Bapat > > wrote: > > > > > > On Tue, Apr 5, 2022 at 6:21 AM Peter Smith wrote: > > > > > > > > Below are some other name ideas. Maybe they are

Re: Handle infinite recursion in logical replication setup

2022-06-01 Thread vignesh C
On Thu, May 26, 2022 at 4:40 PM Amit Kapila wrote: > > On Fri, May 20, 2022 at 3:31 PM vignesh C wrote: > > > > On Wed, May 18, 2022 at 4:22 PM Amit Kapila wrote: > > > > > > 5. > > > * It is quite possible that subscriber has not yet pulled data to

Re: Handle infinite recursion in logical replication setup

2022-06-01 Thread vignesh C
On Thu, May 26, 2022 at 2:06 PM Peter Smith wrote: > > This post completes my review of patch v15*. > > == > > 1. A general comment affecting both patches > > I realised the things defined in the subscription WITH are referred to > in the PG DOCS as "parameters" (not "options"). See CREATE > S

Re: Handle infinite recursion in logical replication setup

2022-05-25 Thread vignesh C
On Tue, May 24, 2022 at 8:06 AM shiy.f...@fujitsu.com wrote: > > On Tue, May 24, 2022 1:34 AM vignesh C wrote: > > > > Thanks for the comments, the attached v15 patch has the fixes for the same. > > > > Thanks for updating the patch. I have a comment on the documen

Re: Skipping schema changes in publication

2022-05-22 Thread vignesh C
On Sat, May 21, 2022 at 11:06 AM vignesh C wrote: > > On Fri, May 20, 2022 at 11:23 AM Peter Smith wrote: > > > > Below are my review comments for v6-0002. > > > > == > > > > 1. Commit message. > > The psql \d family of commands to display exc

Re: Skipping schema changes in publication

2022-05-20 Thread vignesh C
On Fri, May 20, 2022 at 11:23 AM Peter Smith wrote: > > Below are my review comments for v6-0002. > > == > > 1. Commit message. > The psql \d family of commands to display excluded tables. > > SUGGESTION > The psql \d family of commands can now display excluded tables. Modified > ~~~ > > 2.

Re: Skipping schema changes in publication

2022-05-20 Thread vignesh C
On Fri, May 20, 2022 at 5:49 AM Peter Smith wrote: > > FYI, although the v6-0002 patch applied cleanly, I found that the SGML > was malformed and so the pg docs build fails. > > ~~~ > e.g. > > [postgres@CentOS7-x64 sgml]$ make STYLE=website html > { \ > echo ""; \ > echo ""; \ > } > version.sg

Re: Skipping schema changes in publication

2022-05-20 Thread vignesh C
On Thu, May 19, 2022 at 1:49 PM Peter Smith wrote: > > Below are my review comments for v6-0001. > > == > > 1. General. > > The patch failed 'publication' tests in the make check phase. > > Please add this work to the commit-fest so that the 'cfbot' can report > such errors sooner. Added comm

Re: Handle infinite recursion in logical replication setup

2022-05-20 Thread vignesh C
On Thu, May 19, 2022 at 2:12 PM shiy.f...@fujitsu.com wrote: > > On Wed, May 4, 2022 2:47 PM vignesh C wrote: > > > > Thanks for the comments, the attached v13 patch has the changes for the > > same. > > > > Here are some comments on v13-0002 patch. > >

Re: Handle infinite recursion in logical replication setup

2022-05-20 Thread vignesh C
On Wed, May 18, 2022 at 4:22 PM Amit Kapila wrote: > > On Wed, May 18, 2022 at 10:29 AM Amit Kapila wrote: > > > > On Wed, May 4, 2022 at 12:17 PM vignesh C wrote: > > > > > > Thanks for the comments, the attached v13 patch has the changes for the > >

Re: Handle infinite recursion in logical replication setup

2022-05-20 Thread vignesh C
On Wed, May 18, 2022 at 1:40 PM shiy.f...@fujitsu.com wrote: > > On Wed, May 4, 2022 2:47 PM vignesh C wrote: > > > > Thanks for the comments, the attached v13 patch has the changes for the > > same. > > > > Thanks for your patch. Here are some comments o

Re: Skipping schema changes in publication

2022-05-18 Thread vignesh C
On Tue, May 17, 2022 at 7:35 AM Peter Smith wrote: > > Below are my review comments for v5-0002. > > There may be an overlap with comments recently posted by Osumi-san [1]. > > (I also have review comments for v5-0002; will post them tomorrow) > > == > > 1. General > > Is it really necessary t

Re: Skipping schema changes in publication

2022-05-18 Thread vignesh C
On Mon, May 16, 2022 at 2:00 PM osumi.takami...@fujitsu.com wrote: > > On Saturday, May 14, 2022 10:33 PM vignesh C wrote: > > Thanks for the comments, the attached v5 patch has the changes for the same. > > Also I have made the changes for SKIP Table based on the new syntax, t

Re: Skipping schema changes in publication

2022-05-18 Thread vignesh C
On Wed, May 18, 2022 at 8:30 AM shiy.f...@fujitsu.com wrote: > > On Sat, May 14, 2022 9:33 PM vignesh C wrote: > > > > Thanks for the comments, the attached v5 patch has the changes for the > > same. Also I have made the changes for SKIP Table based on the new > &g

Re: Skipping schema changes in publication

2022-05-18 Thread vignesh C
On Mon, May 16, 2022 at 2:53 PM Peter Smith wrote: > > Below are my review comments for v5-0001. > > There is some overlap with comments recently posted by Osumi-san [1]. > > (I also have review comments for v5-0002; will post them tomorrow) > > == > > 1. Commit message > > This patch adds a n

Re: Skipping schema changes in publication

2022-05-18 Thread vignesh C
On Mon, May 16, 2022 at 8:32 AM osumi.takami...@fujitsu.com wrote: > > On Saturday, May 14, 2022 10:33 PM vignesh C wrote: > > Thanks for the comments, the attached v5 patch has the changes for the same. > > Also I have made the changes for SKIP Table based on the new syntax, t

Re: Skipping schema changes in publication

2022-05-14 Thread vignesh C
On Fri, May 13, 2022 at 9:37 AM Peter Smith wrote: > > On Thu, May 12, 2022 at 2:24 PM vignesh C wrote: > > > ... > > The attached patch has the implementation for "ALTER PUBLICATION > > pubname RESET". This command will reset the publication to default &

Re: First draft of the PG 15 release notes

2022-05-12 Thread vignesh C
I wonder if this is worth mentioning: Raise a WARNING for missing publications. commit 8f2e2bbf145384784bad07a96d461c6bbd91f597 https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8f2e2bbf145384784bad07a96d461c6bbd91f597 Regards, Vignesh On Thu, May 12, 2022 at 7:52 PM Bruce Mom

Re: Skipping schema changes in publication

2022-05-11 Thread vignesh C
On Tue, May 10, 2022 at 9:08 AM vignesh C wrote: > > On Fri, May 6, 2022 at 8:05 AM Peter Smith wrote: > > > > On Thu, Apr 28, 2022 at 9:32 PM Amit Kapila wrote: > > > > > ... > > > > > > Another idea that occurred to me today for tables t

Re: Multi-Master Logical Replication

2022-05-11 Thread vignesh C
xecute the equivalent of all the CREATE PUBLICATION, CREATE > SUBSCRIPTION, and TRUNCATE steps described above. > > Notice this proposal has some external API similarities with the BDR > extension [3] (which also provides multi-master logical replication), > althou

Re: Skipping schema changes in publication

2022-05-09 Thread vignesh C
On Fri, May 6, 2022 at 8:05 AM Peter Smith wrote: > > On Thu, Apr 28, 2022 at 9:32 PM Amit Kapila wrote: > > > ... > > > > Another idea that occurred to me today for tables this is as follows: > > 1. Allow to mention except during create publication ... For All Tables. > > CREATE PUBLICATION pub1

Re: Handle infinite recursion in logical replication setup

2022-05-05 Thread vignesh C
On Thu, May 5, 2022 at 2:41 PM Alvaro Herrera wrote: > > On 2022-May-04, vignesh C wrote: > > > On Mon, May 2, 2022 at 5:49 AM Peter Smith wrote: > > > > 1. Commit message > > > > > > In another thread using the terminology "multi-master" se

Re: Handle infinite recursion in logical replication setup

2022-05-03 Thread vignesh C
On Mon, May 2, 2022 at 5:49 AM Peter Smith wrote: > > Thanks for updating the patches for all my prior feedback. > > For v12* I have only minor feedback for the docs. > > == > V12-0001 > > no comments > > == > V12-0002 > > 1. Commit message > > In another thread using the terminology "mult

Re: Skipping schema changes in publication

2022-04-29 Thread vignesh C
On Thu, Apr 28, 2022 at 4:50 PM osumi.takami...@fujitsu.com wrote: > > On Wednesday, April 27, 2022 9:50 PM vignesh C wrote: > > Thanks for the comments, the attached v3 patch has the changes for the same. > Hi > > Thank you for updating the patch. Several minor comments

<    3   4   5   6   7   8   9   10   11   12   >