BUG #9398: DELETE refering to a materialized view produces "cannot lock rows in materialized view" error

Поиск
Список
Период
Сортировка
От no-email@example.com
Тема BUG #9398: DELETE refering to a materialized view produces "cannot lock rows in materialized view" error
Дата
Msg-id 20140301095125.11734.87903@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #9398: DELETE refering to a materialized view produces "cannot lock rows in materialized view" error
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      9398
Logged by:          nakag
Email address:      no-email@example.com
PostgreSQL version: 9.3.3
Operating system:   Linux
Description:

CREATE TABLE base ( id int primary key );
CREATE MATERIALIZED VIEW mv AS SELECT * FROM base;
CREATE TABLE d ( id int primary key );
DELETE FROM d WHERE EXISTS ( SELECT * FROM mv WHERE mv.id = d.id );

The above code produces an ERROR "cannot lock rows in materialized view."

В списке pgsql-bugs по дате отправления: