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-0008Gx-Hc@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/bf4052faa1c289883799d49f063715161a8a4f1e

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
Дата:
Сообщение: pgsql: C comment update: relfilenode is only unique with a tablespace
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: pgsql: isdigit() needs an unsigned char argument.