Hello there
have some problems on 7.2.3/freebsd
ex.
table1 has 2 columns: id and name
table2 has 3 columns: id, t1_id(references t1(id) on delete cascade) and
'name' field
i got a procedure (plpgsql)
declare i int;
begin select count(*) into i from table2 where t1_id=123; raise notice ''rows selected: %'',i; delete from table1 where
id=123;select count(*) into i from table2 where t1_id=123; raise notice ''rows selected: %'',i;
end;
the constraint trigger on delete executes ONLY after procedurecompletion, but it does not execute right after delete.
WHY?
--------------------
Regards,
Eugene Gridasov
mailto:eugene@spider.ru