Re: Rules and Command Status - update/insert/delete rule with series of commands in action

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "johnlumby@hotmail.com" <johnlumby@hotmail.com>
Cc: pgsql-general@lists.postgresql.org, Adrian Klaver <adrian.klaver@aklaver.com>, "David G. Johnston" <david.g.johnston@gmail.com>
Date: 2024-05-31T01:34:07Z
Lists: pgsql-general
"johnlumby@hotmail.com" <johnlumby@hotmail.com> writes:
> But I suppose that my next question,   given what you both say about the 
> RULE system being a dead-end,  is whether there is any likelihood of 
> supporting an INSTEAD OF trigger on a view at statement level?   Maybe 
> that stands more chance of going somewhere?

Perhaps, but I don't know of anyone working on it.

IIRC, the row-level-only restriction dates from before we had
implemented transition tables, so that at the time there was
nothing very meaningful that a statement-level trigger could do.
Maybe that problem has gone away, though I've not thought
about it very hard.

			regards, tom lane