• Tom Lane's avatar
    Fix dumping of a materialized view that depends on a table's primary key. · 62215de2
    Tom Lane authored
    It is possible for a view or materialized view to depend on a table's
    primary key, if the view query relies on functional dependency to
    abbreviate a GROUP BY list.  This is problematic for pg_dump since we
    ordinarily want to dump view definitions in the pre-data section but
    indexes in post-data.  pg_dump knows how to deal with this situation for
    regular views, by breaking the view's ON SELECT rule apart from the view
    proper.  But it had not been taught what to do about materialized views,
    and in fact mistakenly dumped them as regular views in such cases, as
    seen in bug #9616 from Jesse Denardo.
    
    If we had CREATE OR REPLACE MATERIALIZED VIEW, we could fix this in a
    manner analogous to what's done for regular views; but we don't yet,
    and we'd not back-patch such a thing into 9.3 anyway.  As a hopefully-
    temporary workaround, break the circularity by postponing the matview
    into post-data altogether when this case occurs.
    62215de2
pg_dump.c 456 KB