Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1awBtW-00018n-Ba for pgsql-docs@arkaria.postgresql.org; Fri, 29 Apr 2016 17:07:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1awBtV-0005w8-Qz for pgsql-docs@arkaria.postgresql.org; Fri, 29 Apr 2016 17:07:57 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1awBt9-0005XM-AU for pgsql-docs@postgresql.org; Fri, 29 Apr 2016 17:07:35 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1awBt5-0007pk-UK for pgsql-docs@postgresql.org; Fri, 29 Apr 2016 17:07:33 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 43A3B202B5 for ; Fri, 29 Apr 2016 13:07:30 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute6.internal (MEProxy); Fri, 29 Apr 2016 13:07:30 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=rR/9vWHYkWUE2jW 73Rf6mZZiUSU=; b=RsKzKWdpIrbkZr09wHVNiQUD7ej1nHrPSqJRs+2gRP6lLKX nm+bRUnbP3XAiwMhw5kXg1S80D9Di+q+z72NTC2Y76dYBRblIJmoBaBkumgOVisV wNMhXq7rUIdNGDlkWXl2oZFBLgthRfNTX8ThBbAfZ98yDR7Gayt21WvrHEd4= X-Sasl-enc: Rahf2NJqhIZRdiNtFj+lU6/ZD2j4P4AmNHema+xI/QP7 1461949649 Received: from vanquo.pezone.net (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id C1B7D680147; Fri, 29 Apr 2016 13:07:29 -0400 (EDT) Subject: Re: 36.1 Overview of Trigger Behavior To: Dmitry Igrishin , pgsql-docs References: From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <572394D1.2020502@2ndquadrant.com> Date: Fri, 29 Apr 2016 13:07:29 -0400 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101 Icedove/38.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On 08/11/2015 05:51 AM, Dmitry Igrishin wrote: > Subparagraph 8: > I suggest to replace > "BEFORE row-level triggers to execute" > with > "row-level BEFORE triggers to execute" > for consistency. Fixed that one. Wasn't so sure about the one below. > > Subparagraph 14: > While WHEN can be used with INSERT too, I suggest to replace > "However, in an AFTER trigger, the WHEN condition is > evaluated just after the row update occurs, and it determines > whether an event is queued to fire the trigger at the end of > statement." > with > "However, in an AFTER trigger, the WHEN condition is > evaluated just after the row inserted or updated, and it determines > whether an event is queued to fire the trigger at the end of > statement." -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs