Re: Delete rules and functions

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Wiebe Cazemier <halfgaar(at)gmx(dot)net> writes:
> I have the following scenerio:

> a rule on a view which executes a function by means of a select call, which in
> turn deletes from a table which has on-delete rules on it. When the function
> is called from the rule, the subsequent delete call in the function doesn't
> cause the on-delete rules on the table to be taken into account.

Please provide an example, because the rewriter is most certainly
applied to queries from functions.

I suspect you are actually being burnt by some other effect, like a row
disappearing from the view as soon as its underlying data is deleted.

			regards, tom lane