diff options
| author | Kevin Grittner <kgrittn@postgresql.org> | 2013-10-09 14:26:09 -0500 |
|---|---|---|
| committer | Kevin Grittner <kgrittn@postgresql.org> | 2013-10-09 14:26:09 -0500 |
| commit | f566515192461acd8d9c232f48ddac3fc965cfd8 (patch) | |
| tree | d8609adb64a67bcaadbd1142bd074911aa158d87 /src/include/catalog/pg_opclass.h | |
| parent | 1cccce50f374cfc6081850aedce8eb0f8b274bc5 (diff) | |
| download | postgresql-f566515192461acd8d9c232f48ddac3fc965cfd8.tar.gz | |
Add record_image_ops opclass for matview concurrent refresh.
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.
Diffstat (limited to 'src/include/catalog/pg_opclass.h')
| -rw-r--r-- | src/include/catalog/pg_opclass.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/include/catalog/pg_opclass.h b/src/include/catalog/pg_opclass.h index f714db567e..0a3eb3e1f7 100644 --- a/src/include/catalog/pg_opclass.h +++ b/src/include/catalog/pg_opclass.h @@ -143,6 +143,7 @@ DATA(insert ( 405 oid_ops PGNSP PGUID 1990 26 t 0 )); DATA(insert ( 403 oidvector_ops PGNSP PGUID 1991 30 t 0 )); DATA(insert ( 405 oidvector_ops PGNSP PGUID 1992 30 t 0 )); DATA(insert ( 403 record_ops PGNSP PGUID 2994 2249 t 0 )); +DATA(insert ( 403 record_image_ops PGNSP PGUID 3194 2249 f 0 )); DATA(insert OID = 3126 ( 403 text_ops PGNSP PGUID 1994 25 t 0 )); #define TEXT_BTREE_OPS_OID 3126 DATA(insert ( 405 text_ops PGNSP PGUID 1995 25 t 0 )); |
