From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wiebe Cazemier <halfgaar@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Delete rules and functions
Date: Tue, 26 Jun 2007 16:50:12 -0400
Message-ID: <28442.1182891012@sss.pgh.pa.us> (raw)
In-Reply-To: <f5rpk6$r8n$1@sea.gmane.org>
References: <f5rpk6$r8n$1@sea.gmane.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, halfgaar@gmx.net
Subject: Re: Delete rules and functions
In-Reply-To: <28442.1182891012@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox