RE: Handle infinite recursion in logical replication setup - Mailing list pgsql-hackers

From kuroda.hayato@fujitsu.com
Subject RE: Handle infinite recursion in logical replication setup
Date
Msg-id TYAPR01MB5866CE229F257F246620F5E3F5089@TYAPR01MB5866.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Handle infinite recursion in logical replication setup  (Peter Smith <smithpb2250@gmail.com>)
Responses Re: Handle infinite recursion in logical replication setup  (Peter Smith <smithpb2250@gmail.com>)
List pgsql-hackers
Dear Peter,

> > So, why does the patch use syntax option 1?

IMU it might be useful for the following case.

Assuming that multi-master configuration with node1, node2.
Node1 has a publication pub1 and a subscription sub2, node2 has pub2 and sub1.

From that situation, please consider that new node node3 is added
that subscribe some changes from node2.

If the feature is introduced as option1, new publication must be defined in node2.
If that is introduced as option2, however, maybe pub2 can be reused.
i.e. multiple declaration of publications can be avoided.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED


pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: pl/pgsql feature request: shorthand for argument and local variable references
Next
From: Peter Smith
Date:
Subject: Re: Handle infinite recursion in logical replication setup