On Mon, Dec 16, 2013 at 9:16 PM, Josh Berkus <josh@agliodbs.com> wrote:
> 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.
/me scratches head.
So, put a BEFORE trigger, and make it return NULL. Same effect,
different notation.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company