Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 7107F8E3529 for ; Sat, 3 Mar 2012 09:45:37 -0400 (AST) Received: from acidenitrix.villemain.org ([91.121.90.165]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S3pHE-0001pT-0g for pgsql-hackers@postgresql.org; Sat, 03 Mar 2012 13:45:37 +0000 Received: from 89-158-241-83.rev.dartybox.com ([89.158.241.83] helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1S3pGw-0003Jr-44; Sat, 03 Mar 2012 14:45:18 +0100 Received: by DimIMac.local (Postfix, from userid 501) id AE97B3C263E7; Sat, 3 Mar 2012 14:45:10 +0100 (CET) From: Dimitri Fontaine To: Robert Haas Cc: Kevin Grittner , Thom Brown , Tom Lane , Dimitri Fontaine , PostgreSQL Hackers Subject: Re: Command Triggers, patch v11 Organization: 2ndQuadrant References: <4965.1330441437@sss.pgh.pa.us> <4F4C99AD0200002500045C72@gw.wicourts.gov> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Sat, 03 Mar 2012 14:45:10 +0100 In-Reply-To: (Robert Haas's message of "Fri, 2 Mar 2012 19:12:46 -0500") Message-ID: User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.93 (darwin) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/110 X-Sequence-Number: 203992 Robert Haas writes: >>> =C2=A0 =C2=A0 =C2=A0 CREATE COMMAND TRIGGER name ... properties ...; >>> =C2=A0 =C2=A0 =C2=A0 DROP COMMAND TRIGGER name; >>> >>> full stop. =C2=A0If you want to run the same trigger function on some >>> more commands, add another trigger name. >> >> +1 > > +1. I suggested the same thing a while back. Yeah, I know, I just wanted to hear from more people before ditching out a part of the work I did, and Thom was balancing in the opposite direction. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support