Delete rules and functions

From: Wiebe Cazemier <halfgaar(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Delete rules and functions
Date: 2007-06-26 19:32:22
Message-ID: f5rpk6$r8n$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2007-06-26 19:52:33 Re: yet another simple SQL question
Previous Message Chris Browne 2007-06-26 18:11:39 Re: Vacation days