Viacheslav N Tararin <[EMAIL PROTECTED]> writes:
> For the next schema rule "d_analysis_plan" perform only first DELETE
> statement, second statement not performed.
You did not show us the definition of "analysis_plan", but I'll bet it's
a view joining t_sub_plan and t_account_plan. If so, this is not a bug.
After the first DELETE, there is no longer anything in the view matching
the id, and so the second DELETE finds nothing to delete.
You might have better luck using ON DELETE CASCADE foreign-key
references to accomplish the results you want.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
