• Peter Eisentraut's avatar
    Fix filtering of unsupported relations in logical replication · bc1adc65
    Peter Eisentraut authored
    In the pgoutput plugin, skip changes for relations that are not
    publishable, per is_publishable_class().  This concerns in particular
    materialized views and information_schema tables.  While those relations
    cannot be part of a publication, per existing checks, they will be
    considered by a FOR ALL TABLES publication.  A subscription would not
    actually apply changes for those relations, again per existing checks,
    but trying to match incoming changes to local tables on the subscriber
    would lead to errors if no matching local table exists.  Skipping those
    changes on the publisher avoids sending useless changes and eliminates
    the error.
    
    Bug: #15044
    Reported-by: default avatarChad Trabant <chad@iris.washington.edu>
    Reviewed-by: default avatarPetr Jelinek <petr.jelinek@2ndquadrant.com>
    bc1adc65
pgoutput.c 16.6 KB