Eugene Gridasov ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is.
Short Description triggers do not execute in right order in procedures Long Description The constraint trigger on delete executes ONLY after procedure completion, but it does not execute right after delete. WHY? Sample Code 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; No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
