Re: [SQL] Delete rules and functions

2007-06-26 Thread Wiebe Cazemier
On Tuesday 26 June 2007 22:50, Tom Lane wrote: > 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 delete

Re: [SQL] Delete rules and functions

2007-06-26 Thread Tom Lane
Wiebe Cazemier <[EMAIL PROTECTED]> 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 f

[SQL] Delete rules and functions

2007-06-26 Thread Wiebe Cazemier
Hi, 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 t