Rule execution bug
| От | Viacheslav N Tararin |
|---|---|
| Тема | Rule execution bug |
| Дата | |
| Msg-id | 3F731ABB.3070909@dekasoft.com.ua обсуждение исходный текст |
| Ответы |
Re: Rule execution bug
|
| Список | pgsql-bugs |
For the next schema rule "d_analysis_plan" perform only first DELETE
statement, second statement not performed.
Environment:
---------------------------------
PostgreSQL 7.4beta4
CPU: 2PIII800
ASP Linux 7.2 2.4.19-13 smp
gcc 2.96
SCHEMA:
------------------------------------------
create table gl.T_ACCOUNT (
ID INTEGER not null,
PLAN_ID INTEGER not null,
CODE ltree not null check (
CODE != ''::ltree),
DESCRIPTION VARCHAR(255) not null check (
DESCRIPTION != ''),
STATUS_ID INTEGER not null,
VERSION SMALLINT not null
);
create table gl.T_ACCOUNT_PLAN (
ID INTEGER not null,
CODE VARCHAR(17) not null check (
CODE != '' ),
DESCRIPTION VARCHAR(255) not null check (
DESCRIPTION != ''),
VERSION SMALLINT not null
);
create table gl.T_SUB_PLAN (
ID INTEGER not null,
ACCOUNT_ID INTEGER not null,
MIRROR_ID INTEGER
);
alter table gl.T_ACCOUNT
add constraint FK1_ACCOUNT foreign key (PLAN_ID)
references gl.T_ACCOUNT_PLAN (ID);
alter table gl.T_SUB_PLAN
add constraint FK1_SUB_PLAN foreign key (ACCOUNT_ID)
references gl.T_ACCOUNT (ID);
alter table gl.T_SUB_PLAN
add constraint FK2_SUB_PLAN foreign key (ID)
references gl.T_ACCOUNT_PLAN (ID);
CREATE RULE d_analysis_plan AS ON DELETE TO analysis_plan DO INSTEAD
(DELETE
FROM gl.t_sub_plan
WHERE (t_sub_plan.id = old.id );
DELETE
FROM gl.t_account_plan
WHERE ((t_account_plan.id = old.id )
AND (t_account_plan."version" = old."version" ));
);
В списке pgsql-bugs по дате отправления: