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

[Peter Smith]

On Tue, Oct 20, 2026 at 2:30 PM shveta malik <shveta.ma...@gmail.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

v4-0001-Error-if-same-table-has-ONLY-mismatch.patch
Description: Binary data