Delete rules and functions - Mailing list pgsql-sql

From Wiebe Cazemier
Subject Delete rules and functions
Date
Msg-id f5rpk6$r8n$1@sea.gmane.org
Whole thread Raw
Responses Re: Delete rules and functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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 the table to be taken into account.

Is that a bug? Or is the query rewriting not possible from inside functions?



pgsql-sql by date:

Previous
From: Chris Browne
Date:
Subject: Re: Vacation days
Next
From: "news.gmane.org"
Date:
Subject: Re: Where clause