From: | Peter Smith <smithpb2250(at)gmail(dot)com> |
---|---|
To: | vignesh C <vignesh21(at)gmail(dot)com> |
Cc: | Zheng Li <zhengli10(at)gmail(dot)com>, Ajin Cherian <itsajin(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Japin Li <japinli(at)hotmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Support logical replication of DDLs |
Date: | 2022-10-10 02:38:26 |
Message-ID: | CAHut+PtKiTmcQ7zXs6YvR-qtuMQ9wgffnfamqCAVpM_ETa2LCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi,
Please include all known information about how this feature looks from
the user's POV.
Ideally, this information should be in the form of PGDOCS updates
included in patch 00001.
I think documenting these details should not be deferred - reviewers
will want to experiment with the feature, and also to be able to
consider about any behaviour pros/cons.
~
e.g. I can guess from the patch 0004 test cases maybe it currently
looks like this:
CREATE PUBLICATION mypub FOR ALL TABLES with (publish = 'insert,
update, delete, ddl')
But without documented details, that just raises more questions:
e.g.
- Does it mean the DDL replication all-or-nothing? What if I only want
to create missing tables, but not everything else?
- Is 'ddl' publish option able to be specified when using CREATE
PUBLICATION ... FOR ALL TABLES?
- What if I want to replicate DDL but not data (e.g. for making an
empty "test" database)? Will just saying publish='ddl' allow that?
- etc.
------
Kind Regards,
Peter Smith.
Fujitsu Australia
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-10-10 02:45:54 | Re: Different execution plan between PostgreSQL 8.4 and 12.11 |
Previous Message | gzh | 2022-10-10 02:32:56 | Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11 |
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2022-10-10 02:51:32 | Re: Allow file inclusion in pg_hba and pg_ident files |
Previous Message | Richard Guo | 2022-10-10 02:35:04 | Unnecessary lateral dependencies implied by PHVs |