Re: Why no INSTEAD OF triggers on tables? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Why no INSTEAD OF triggers on tables?
Date
Msg-id 52AFB3F8.5080307@agliodbs.com
Whole thread Raw
In response to Why no INSTEAD OF triggers on tables?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Why no INSTEAD OF triggers on tables?
List pgsql-hackers
On 12/16/2013 04:22 PM, Tom Lane wrote:
> Josh Berkus <josh@agliodbs.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



pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Race condition in b-tree page deletion
Next
From: "imagenesis@gmail.com"
Date:
Subject: dpkg-buildpackage fails on 9.2.6 on ubuntu 12.04.3 LTS