pgsql: Fix handling of temp and unlogged tables in FOR ALL TABLESpubli - Mailing list pgsql-committers

From Peter Eisentraut
Subject pgsql: Fix handling of temp and unlogged tables in FOR ALL TABLESpubli
Date
Msg-id E1hH2AO-0004or-LS@gemulon.postgresql.org
Whole thread Raw
List 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
------
REL_11_STABLE

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

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


pgsql-committers by date:

Previous
From: Amit Langote
Date:
Subject: Re: pgsql: Fix plan created for inherited UPDATE/DELETE with alltables exc
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Fix plan created for inherited UPDATE/DELETE with all tables exc