pgsql: Allow publications with schema and table of the same schema.

2022-09-22 Thread Amit Kapila
Allow publications with schema and table of the same schema. We previously thought that allowing such cases can confuse users when they specify DROP TABLES IN SCHEMA but that doesn't seem to be the case based on discussion. This helps to uplift the restriction during ALTER TABLE ... SET SCHEMA whi

pgsql: Allow publications with schema and table of the same schema.

2022-09-22 Thread Amit Kapila
Allow publications with schema and table of the same schema. We previously thought that allowing such cases can confuse users when they specify DROP TABLES IN SCHEMA but that doesn't seem to be the case based on discussion. This helps to uplift the restriction during ALTER TABLE ... SET SCHEMA whi