BUG #9398: DELETE refering to a materialized view produces "cannot lock rows in materialized view" error - Mailing list 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."