| From: | vignesh C <vignesh21(at)gmail(dot)com> |
|---|---|
| To: | Peter Smith <smithpb2250(at)gmail(dot)com> |
| Cc: | shveta malik <shveta(dot)malik(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Euler Taveira <euler(at)eulerto(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, Hou, Zhijie/侯 志杰 <houzj(dot)fnst(at)fujitsu(dot)com>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
| Subject: | Re: Logical Replication of sequences |
| Date: | 2024-08-12 13:10:58 |
| Message-ID: | CALDaNm1oeKOFuKdW_2Ox+iMPg-kQ=y1yVsyufmgPAkwX5pJGrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 12 Aug 2024 at 09:59, Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
>
> Hi Vignesh,
>
> I noticed it is not currently possible (there is no syntax way to do
> it) to ALTER an existing publication so that it will publish
> SEQUENCES.
>
> Isn't that a limitation? Why?
>
> For example,. Why should users be prevented from changing a FOR ALL
> TABLES publication into a FOR ALL TABLES, SEQUENCES one?
>
> Similarly, there are other combinations not possible
> DROP ALL SEQUENCES from a publication that is FOR ALL TABLES, SEQUENCES
> DROP ALL TABLES from a publication that is FOR ALL TABLES, SEQUENCES
> ADD ALL TABLES to a publication that is FOR ALL SEQUENCES
Yes, this should be addressed. However, I'll defer it until the
current set of patches is finalized and all comments have been
resolved.
Regards,
Vignesh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksander Alekseev | 2024-08-12 13:13:02 | Re: [PATCH] Add crc32(text) & crc32(bytea) |
| Previous Message | vignesh C | 2024-08-12 13:07:21 | Re: Logical Replication of sequences |