pgsql: Fix handling of temp and unlogged tables in FOR ALL TABLES publi

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix handling of temp and unlogged tables in FOR ALL TABLES publi
Date: 2019-04-18 08:13:08
Message-ID: E1hH2AO-0004op-Ld@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix handling of temp and unlogged tables in FOR ALL TABLES publications

If a FOR ALL TABLES publication exists, temporary and unlogged tables
are ignored for publishing changes. But CheckCmdReplicaIdentity()
would still check in that case that such a table has a replica
identity set before accepting updates. To fix, have
GetRelationPublicationActions() return that such a table publishes no
actions.

Discussion: https://www.postgresql.org/message-id/f3f151f7-c4dd-1646-b998-f60bd6217dd3@2ndquadrant.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/bb385c4fb0f4eb33d2bc7e484061565ba51cc790

Modified Files
--------------
src/backend/utils/cache/relcache.c | 7 +++++++
src/test/subscription/t/100_bugs.pl | 37 ++++++++++++++++++++++++++++++++++++-
2 files changed, 43 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-04-18 19:41:37 Re: pgsql: Fix plan created for inherited UPDATE/DELETE with all tables exc
Previous Message Amit Langote 2019-04-18 02:42:49 Re: pgsql: Fix plan created for inherited UPDATE/DELETE with all tables exc