projects / users / bernd / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0024a3a) | patch
Don't reject ROW_MARK_REFERENCE rowmarks for materialized views.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 6 Mar 2014 16:37:02 +0000 (11:37 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 6 Mar 2014 16:37:02 +0000 (11:37 -0500)
commitbf4052faa1c289883799d49f063715161a8a4f1e
tree382f6b0b2589d42cb378b23b19c3b6d277c862dftree
parent0024a3a3b6cfdca9d5c00f8ac5d5809f2e7ec3a5commit | diff
Don't reject ROW_MARK_REFERENCE rowmarks for materialized views.

We should allow this so that matviews can be referenced in UPDATE/DELETE
statements in READ COMMITTED isolation level.  The requirement for that
is that a re-fetch by TID will see the same row version the query saw
earlier, which is true of matviews, so there's no reason for the
restriction.  Per bug #9398.

Michael Paquier, after a suggestion by me
src/backend/executor/execMain.c diff | blob | blame | history
src/test/regress/expected/matview.out diff | blob | blame | history
src/test/regress/sql/matview.sql diff | blob | blame | history
Bernd Helmle's repository