Re: Command Triggers

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: Robert Haas <robertmhaas@gmail.com>, Alvaro Herrera <alvherre@commandprompt.com>, Greg Smith <greg@2ndquadrant.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2011-12-18T14:21:31Z
Lists: pgsql-hackers
Dimitri Fontaine wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > We have a big user community and what _you_ want for this feature is
> > only a small part of our decision on what is needed.  Robert's concern
> > that this might not be useful enough for the general use-cases people
> > want is a legitimate, if difficult to hear, analysis.
> 
> Agreed, his concern is legitimate.  Now, I've never been trying to
> implement a generic event trigger system and I don't know what it would
> take to implement such a beast.
> 
> Transaction BEGIN, COMMIT, and ROLLBACK triggers anyone?  not me?:)
> 
> Exploring if my proposal would be a pain to maintain once we have a fully
> generic event trigger system someday is legitimate, asking me to design
> both the generic event system and the command triggers so that they fit
> in is just asking for too much.

Agreed.  I am not against this addition, just pointing out that we have
to be careful.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +