To: Wiebe Cazemier <halfgaar@gmx.net>
cc: pgsql-sql@postgresql.org
Subject: Re: Delete rules and functions 
In-reply-to: <f5rpk6$r8n$1@sea.gmane.org> 
References: <f5rpk6$r8n$1@sea.gmane.org>
Comments: In-reply-to Wiebe Cazemier <halfgaar@gmx.net>
	message dated "Tue, 26 Jun 2007 21:32:22 +0200"
Date: Tue, 26 Jun 2007 16:50:12 -0400
Message-ID: <28442.1182891012@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Wiebe Cazemier <halfgaar@gmx.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