Re: Where Clause not being applied to all tables in a publication

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Brad Nicholson <brad(dot)nicholson(at)instacart(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Where Clause not being applied to all tables in a publication
Date: 2023-08-30 18:46:53
Message-ID: CAKFQuwbdGp0Hh5YLHv+A3RVrgmoFHfN8cK1ZAmrRFj1_YVHy0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wednesday, August 30, 2023, Brad Nicholson <brad(dot)nicholson(at)instacart(dot)com>
wrote:

> When adding more than one table to a logical replication publication with
> a where clause, the where clause is only applied to a single table in the
> publication, not all of them.
>

The observed behavior is precisely what the syntax describes.

David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Sanford 2023-08-30 20:44:16 Re: BUG #18076: Consistently receiving Signal 7 and Signal 11 errors
Previous Message Brad Nicholson 2023-08-30 18:43:22 Where Clause not being applied to all tables in a publication