The following bug has been logged on the website:
Bug reference: 9398
Logged by: nakag
Email address: no-email(at)example(dot)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."