pgsql: Don't reject ROW_MARK_REFERENCE rowmarks for materialized views.
От
Tom Lane
Тема
pgsql: Don't reject ROW_MARK_REFERENCE rowmarks for materialized
views.
Дата
Msg-id
E1WLbII-0008Gz-J8@gemulon.postgresql.org
Список
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 Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/3973034e6dc599de2203ed812f783a57b63dce5c Modified Files -------------- src/backend/executor/execMain.c | 13 +++++++------ src/test/regress/expected/matview.out | 26 ++++++++++++++++++++++++++ src/test/regress/sql/matview.sql | 8 ++++++++ 3 files changed, 41 insertions(+), 6 deletions(-)
В списке pgsql-committers по дате отправления
От: Bruce Momjian
Дата: