User-Agent: Cyrus-JMAP/3.5.0-alpha0-4778-g14fba9972e-fm-20220217.001-g14fba997
Mime-Version: 1.0
Message-Id: <eb0ae88d-954c-4e74-8a77-b1d01f096dff@www.fastmail.com>
In-Reply-To: <f0522a9b-eb33-20d4-06ca-b7668dcd434d@enterprisedb.com>
References: <d045f3c2-6cfb-06d3-5540-e63c320df8bc@enterprisedb.com>
 <22aef14d-0ea1-9044-c2e7-29f88762eaec@enterprisedb.com>
 <32540e16-fab6-f790-b99b-5a8fca8bde52@enterprisedb.com>
 <3B014BE4-EE61-4834-8FF6-937B43C46BC7@enterprisedb.com>
 <3d68b45a-ceb5-6824-3a39-f53411fd0c88@enterprisedb.com>
 <802f8b1b-a798-be52-c829-7f0fb9faafd5@enterprisedb.com>
 <983bf0c7-9757-fd13-3896-8452cf4c4c52@enterprisedb.com>
 <9211312a-6501-1caf-ee7b-c0d4814b6091@enterprisedb.com>
 <41ada110-bc7c-32a3-08bd-fb5023dd74ba@enterprisedb.com>
 <bb8704a1-96e1-aa9c-aad7-6b006ef7dcd9@enterprisedb.com>
 <2eed0f76-3a1a-8b8b-ac1b-e0f9a0d98287@enterprisedb.com>
 <f242d058-be79-6a59-5497-0bb256cafcc7@enterprisedb.com>
 <e890448d-00b5-18d0-e894-85d17660d484@enterprisedb.com>
 <9defb937-20a9-1d9f-6972-f1c4b4da4f73@enterprisedb.com>
 <CAA4eK1K81djyw3DgPw0GOZr9C1VPo6R2avHf0_qoOFnONNKJFw@mail.gmail.com>
 <0476eb3a-bfe7-9477-540c-ac42d1f16760@enterprisedb.com>
 <4e158021-248d-43ad-95e5-943334bd1007@www.fastmail.com>
 <f0522a9b-eb33-20d4-06ca-b7668dcd434d@enterprisedb.com>
Date: Wed, 23 Feb 2022 19:05:58 -0300
From: "Euler Taveira" <euler@eulerto.com>
To: "Tomas Vondra" <tomas.vondra@enterprisedb.com>,
 "Amit Kapila" <amit.kapila16@gmail.com>
Cc: "Peter Eisentraut" <peter.eisentraut@enterprisedb.com>,
 "Petr Jelinek" <petr.jelinek@enterprisedb.com>,
 "PostgreSQL Hackers" <pgsql-hackers@lists.postgresql.org>
Subject: Re: logical decoding and replication of sequences
Content-Type: multipart/alternative;
 boundary=7664f3233d634af18182fad86efe6890
Archived-At: <https://www.postgresql.org/message-id/eb0ae88d-954c-4e74-8a77-b1d01f096dff%40www.fastmail.com>
Precedence: bulk

--7664f3233d634af18182fad86efe6890
Content-Type: text/plain

On Wed, Feb 23, 2022, at 4:18 PM, Tomas Vondra wrote:
> On 2/23/22 18:33, Euler Taveira wrote:
> > On Wed, Feb 23, 2022, at 1:07 PM, Tomas Vondra wrote:
> >> Maybe, but I don't think it's very common to have that many
> >> schemas added to the same publication. And it probably does not
> >> make much difference whether you have 1000 or 2000 items in the
> >> list - either both are acceptable or unacceptable, I think.
> >
> > Wouldn't it confuse users? Hey, duplicate publication. How? Wait.
> > Doh.
> > 
> 
> I don't follow. Duplicate publications? This talks about rows in
> pg_publication_namespace, not pg_publication.
I was referring to

  Publications:
      "testpub_schemas" (sequences)
      "testpub_schemas" (tables)

versus

  Publications:
      "testpub_schemas" (tables, sequences)

I prefer the latter.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

--7664f3233d634af18182fad86efe6890
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso=
Normal,p.MsoNoSpacing{margin:0}</style></head><body><div>On Wed, Feb 23,=
 2022, at 4:18 PM, Tomas Vondra wrote:<br></div><blockquote type=3D"cite=
" id=3D"qt" style=3D""><div>On 2/23/22 18:33, Euler Taveira wrote:<br></=
div><div>&gt; On Wed, Feb 23, 2022, at 1:07 PM, Tomas Vondra wrote:<br><=
/div><div>&gt;&gt; Maybe, but I don't think it's very common to have tha=
t many<br></div><div>&gt;&gt; schemas added to the same publication. And=
 it probably does not<br></div><div>&gt;&gt; make much difference whethe=
r you have 1000 or 2000 items in the<br></div><div>&gt;&gt; list - eithe=
r both are acceptable or unacceptable, I think.<br></div><div>&gt;<br></=
div><div>&gt; Wouldn't it confuse users? Hey, duplicate publication. How=
? Wait.<br></div><div>&gt; Doh.<br></div><div>&gt;&nbsp;<br></div><div><=
br></div><div>I don't follow. Duplicate publications? This talks about r=
ows in<br></div><div>pg_publication_namespace, not pg_publication.<br></=
div></blockquote><div>I was referring to<br></div><div><br></div><div>&n=
bsp; Publications:<br></div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "testpub=
_schemas" (sequences)<br></div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "test=
pub_schemas" (tables)<br></div><div><br></div><div>versus</div><div><br>=
</div><div>&nbsp; Publications:<br></div><div>&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; "testpub_schemas" (tables, sequences)<br></div><div><br></div><div>=
I prefer the latter.</div><div><br></div><div><br></div><div id=3D"sig11=
2409080"><div class=3D"signature">--<br></div><div class=3D"signature">E=
uler Taveira<br></div><div class=3D"signature">EDB&nbsp;&nbsp; <a href=3D=
"https://www.enterprisedb.com/">https://www.enterprisedb.com/</a><br></d=
iv></div><div><br></div></body></html>
--7664f3233d634af18182fad86efe6890--