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