Horton

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

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: bb385c4fb0f4eb33d2bc7e484061565ba51cc790
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2019-04-18T06:55:55Z
Releases: 12.0 
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

Files

PathChange+/−
src/backend/utils/cache/relcache.c modified +7 −0
src/test/subscription/t/100_bugs.pl modified +36 −1

Discussion