Re: Column level triggers

From: Decibel! <decibel(at)decibel(dot)org>
To: Laurent Wandrebeck <l(dot)wandrebeck(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Column level triggers
Date: 2008-10-15 15:09:54
Message-ID: EA46DF67-59F5-4C88-AA5E-F2199C942AAE@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Oct 15, 2008, at 3:21 AM, Laurent Wandrebeck wrote:
> According to the documentation (
> http://www.postgresql.org/docs/8.3/interactive/sql-createtrigger.html
> ), the feaure "SQL allows triggers to fire on updates to specific
> columns (e.g., AFTER UPDATE OF col1, col2)" is missing.
> After a bit of research, I found that this feature was in the TODO
> list ( http://wiki.postgresql.org/wiki/Todo#Triggers ), and that a
> patch was proposed on 2005/07.
> Is it going to be implemented soon ? It would greatly help, IMHO, for
> load, and simplify the write of plpgsql functions called by before
> triggers.
> Regards, and keep up the good work, that DBMS (mostly;) rocks !

If the patch was submitted back in 2005 and nothing's happened since
then I'd say the author probably lost interest, which means that it
won't be added until someone else gets interested in it. So I'd
suggest either rolling up your sleeves or dangling a carrot (money)
in front of some of the people that do consulting and back-end hacking.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2008-10-15 15:46:04 Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Previous Message Robert Parker 2008-10-15 15:07:20 Re: Chart of Accounts

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-15 15:13:24 Re: Bogus attribute-number range checks in spi.c
Previous Message Decibel! 2008-10-15 15:06:58 Re: How is random_page_cost=4 ok?