User-Agent: Cyrus-JMAP/3.5.0-alpha0-4778-g14fba9972e-fm-20220217.001-g14fba997
Mime-Version: 1.0
Message-Id: <4e158021-248d-43ad-95e5-943334bd1007@www.fastmail.com>
In-Reply-To: <0476eb3a-bfe7-9477-540c-ac42d1f16760@enterprisedb.com>
References: <d045f3c2-6cfb-06d3-5540-e63c320df8bc@enterprisedb.com>
 <90b4e402-3f07-14f4-deca-5eaca31f70a3@enterprisedb.com>
 <de7e9856-b49f-67bd-2ade-447f2d2cbc4b@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>
Date: Wed, 23 Feb 2022 14:33:34 -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=98f2d9d8cc87453fbd6080c9d1a9a9fa
Archived-At: <https://www.postgresql.org/message-id/4e158021-248d-43ad-95e5-943334bd1007%40www.fastmail.com>
Precedence: bulk

--98f2d9d8cc87453fbd6080c9d1a9a9fa
Content-Type: text/plain

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 think just hard-coding this into CreatePublicationStmt would work, but
> it'll be an issue once/if we start adding more options. I'm not sure if
> it makes sense to replicate other relkinds, but maybe DDL?
Materialized view? As you mentioned DDL, maybe we can use the CREATE
PUBLICATION syntax to select which DDL commands we want to replicate.


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

--98f2d9d8cc87453fbd6080c9d1a9a9fa
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 1:07 PM, Tomas Vondra wrote:<br></div><blockquote type=3D"cite=
" id=3D"qt" style=3D""><div>Maybe, but I don't think it's very common to=
 have that many schemas<br></div><div>added to the same publication. And=
 it probably does not make much<br></div><div>difference whether you hav=
e 1000 or 2000 items in the list - either both<br></div><div>are accepta=
ble or unacceptable, I think.<br></div></blockquote><div>Wouldn't it con=
fuse users? Hey, duplicate publication. How? Wait. Doh.<br></div><div><b=
r></div><blockquote type=3D"cite" id=3D"qt" style=3D""><div>I think just=
 hard-coding this into CreatePublicationStmt would work, but<br></div><d=
iv>it'll be an issue once/if we start adding more options. I'm not sure =
if<br></div><div>it makes sense to replicate other relkinds, but maybe D=
DL?<br></div></blockquote><div>Materialized view? As you mentioned DDL, =
maybe we can use the CREATE<br></div><div>PUBLICATION syntax to select w=
hich DDL commands we want to replicate.<br></div><div><br></div><div><br=
></div><div id=3D"sig112409080"><div class=3D"signature">--<br></div><di=
v class=3D"signature">Euler Taveira<br></div><div class=3D"signature">ED=
B&nbsp;&nbsp; <a href=3D"https://www.enterprisedb.com/">https://www.ente=
rprisedb.com/</a><br></div></div><div><br></div></body></html>
--98f2d9d8cc87453fbd6080c9d1a9a9fa--