]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 13ea43a) | patch
Don't reject ROW_MARK_REFERENCE rowmarks for materialized views.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 6 Mar 2014 16:37:04 +0000 (11:37 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 6 Mar 2014 16:37:04 +0000 (11:37 -0500)
commit3973034e6dc599de2203ed812f783a57b63dce5c
treef103cd3af9a7a2ea5524c67209e19e6dc603bc46tree | snapshot
parent13ea43ab83871a8bed5b9cdf7ec18c62bf63df4fcommit | 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 | history
src/test/regress/expected/matview.out diff | blob | history
src/test/regress/sql/matview.sql diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.