• Kevin Grittner's avatar
    Add record_image_ops opclass for matview concurrent refresh. · f5665151
    Kevin Grittner authored
    REFRESH MATERIALIZED VIEW CONCURRENTLY was broken for any matview
    containing a column of a type without a default btree operator
    class.  It also did not produce results consistent with a non-
    concurrent REFRESH or a normal view if any column was of a type
    which allowed user-visible differences between values which
    compared as equal according to the type's default btree opclass.
    Concurrent matview refresh was modified to use the new operators
    to solve these problems.
    
    Documentation was added for record comparison, both for the
    default btree operator class for record, and the newly added
    operators.  Regression tests now check for proper behavior both
    for a matview with a box column and a matview containing a citext
    column.
    
    Reviewed by Steve Singer, who suggested some of the doc language.
    f5665151
func.sgml 572 KB