Re: feature request for Postgresql Rule system. - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: feature request for Postgresql Rule system.
Date
Msg-id 531936.24951.qm@web31807.mail.mud.yahoo.com
Whole thread Raw
In response to Re: feature request for Postgresql Rule system.  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: feature request for Postgresql Rule system.  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
> Actually, I am seeing some unexpected behavior, or rather behavior that
> I wouldn't expect. After the first UPDATE in the rule, NEW and OLD are
> gone.

I guess the end-result behaviour I am looking for (as you mentioned) is having an update-able view
behave exactly as if it were a table in regard to update and delete statements.  (Delete
statements had a similar behavior behaviour, but I got around that problem by using "delete
cascade" on the leaf tables.)

Regards,

Richard Broersma Jr.

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: Let's play bash the search engine
Next
From: Reece Hart
Date:
Subject: Re: Let's play bash the search engine