Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table - Mailing list pgsql-bugs

From Greg Sabino Mullane
Subject Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table
Date
Msg-id CAKAnmm+csbrmkn5SFUd60SAAfe9P1+srbjuEPWvH+3XNCvDrwA@mail.gmail.com
Whole thread Raw
In response to BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table
Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table
List pgsql-bugs
I don't think this is really a bug, more of a feature request / optimization. However, I do agree this is an important one. I don't see offhand why we can't append the where list to our existing list of important columns. There would be a few downsides, but none that would be worse than going full replica identity or creating a new index. I'll see about making a proof of concept patch and throwing it on -hackers. Will cc you on that.

Cheers,
Greg

pgsql-bugs by date:

Previous
From: Tender Wang
Date:
Subject: Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables
Next
From: Tim McLaughlin
Date:
Subject: Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table