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  (Michael Paquier <michael.paquier@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #9374: some timzone abbver is missing from pg_timezone_abbrevs that are in pg_timezone_names
Следующее
От: davidpf75@gmail.com
Дата:
Сообщение: BUG #9404: (URGENT) problem after calling PQconnectdb, exceptions are not caught