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 procedure completion, but it does not execute right after delete. WHY? -------------------- Regards, Eugene Gridasov mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
