ALTER TABLE DISABLE RULE does not work inside of a transaction

Поиск
Список
Период
Сортировка
От Alex Hunsaker
Тема ALTER TABLE DISABLE RULE does not work inside of a transaction
Дата
Msg-id 34d269d40812291407o549c89dbvacda64f125f3c558@mail.gmail.com
обсуждение исходный текст
Ответы Re: ALTER TABLE DISABLE RULE does not work inside of a transaction
Re: ALTER TABLE DISABLE RULE does not work inside of a transaction
Список pgsql-bugs
Namely it does not disable the rule... Enabling inside of the
transaction seems to work though

Tried both CVS and 8.3.5...

create table trule (a int);
insert into trule (a) values (1);
create rule trule_rule as on update to trule do instead nothing;

update trule set a = 2;
UPDATE 0

begin;
ALTER TABLE trule DISABLE RULE trule_rule;
update trule set a = 2;
UPDATE 0

\d trule
   Table "public.trule"
 Column |  Type   | Modifiers
--------+---------+-----------
 a      | integer |
Disabled rules:
    trule_rule AS
    ON UPDATE TO trule DO INSTEAD NOTHING

rollback;

ALTER TABLE trule DISABLE RULE trule_rule;
update trule set a = 2;
UPDATE 1

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held
Следующее
От: "Alex Hunsaker"
Дата:
Сообщение: Re: ALTER TABLE DISABLE RULE does not work inside of a transaction