On, July 22, 2021 1:38 AM vignesh C <vignes...@gmail.com> wrote: >On Wed, Jul 21, 2021 at 3:14 PM Rahila Syed <mailto:rahilasye...@gmail.com> >wrote: >> More broadly, I am not clear about the behaviour of the patch when a >> publication is created to publish only certain tables, and is later altered >> to publish >> a whole schema. I think such behaviour is legitimate. However, >> AFAIU as per current code we can't update the publication type >> from PUBTYPE_TABLE to PUBTYPE_SCHEMA.
> I initially thought this might not be required for users, I have not made any > change for this, I will try to get a few more people's opinion on this and > then fix it if required. Currently, It's not allowed to ALTER a FOR TABLE PUBLICATION to a FOR ALL TABLES PUBLICATION. So, I am not sure it's legitimate to ALTER a FOR TABLE PUBLICATION to a FOR SCHEMA PUBLICATION. Personally, It sounds more like a separate feature which can be discussed in a separate thread. Best regards, houzj
