Обсуждение: pgsql: Fix handling of temp and unlogged tables in FOR ALL TABLESpubli

Поиск
Список
Период
Сортировка

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

От
Peter Eisentraut
Дата:
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_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/05d151e1382b969a618491486778a349a4857d9a

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