On 12/16/2013 04:22 PM, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> I've looked in the archives, but I can't find a reason why INSTEAD OF
>> triggers were never enabled for tables.
>
> What would that mean exactly? And how would you do the actual update
> when it came time to?
Well, I'm specifically thinking of master partition tables. In that
case, we really want an INSTEAD OF trigger.
It seems a little silly that I need to create a separate view, and then
an INSTEAD OF trigger on the view, in order to get a rows-updated count
back from an INSERT which hits a partitioned table.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com