Re: Publication of same parent table with ONLY-ness mismatch should error

On Tue, Oct 20, 2026 at 2:30 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
...
>
> Should we also add tests for the EXCEPT clause, as it touches EXCEPT?
>
> postgres=# create publication pub1 for all tables except(table only
> testpub_tbl_parent, testpub_tbl_parent);
> ERROR: conflicting ONLY specifications for table "testpub_tbl_parent"
>

I think having EXCEPT tests for ONLY-ness mismatch will execute the
same internal logic (OpenTableList) that is already being tested.

I've added a few EXCEPT tests just for completeness. To make them a
bit different, they are using ALTER PUBLICATION.

PSA patch v4.

======
Kind Regards,
Peter Smith.
Fujitsu Australia