Thanks to alecm on freenode for the idea. Thanks also to Andres Freund for pointing out a hole in the first implementation.
Access control is an excellent reason for allowing writes to a VIEW but not to the underlying table. You would ideally like that VIEW to act exactly like a TABLE, but when you put an INSTEAD OF trigger in there, what's coming back isn't necessarily what you'd expect...
Continue reading "VIEW triggers RETURNING..." »
(Page 1 of 1, totaling 1 entries)