Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iUixu-0000BW-KV for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Nov 2019 03:05:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iUixt-0004pf-6j for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Nov 2019 03:05:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iUixs-0004pT-U7; Wed, 13 Nov 2019 03:05:04 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iUixq-0000Wi-9z; Wed, 13 Nov 2019 03:05:04 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1iUixn-000415-V0; Tue, 12 Nov 2019 22:04:59 -0500 Date: Tue, 12 Nov 2019 22:04:59 -0500 From: Bruce Momjian To: Liudmila Mantrova Cc: Eugen Konkov , PostgreSQL-development , pgsql-docs@lists.postgresql.org Subject: Re: Does 'instead of delete' trigger support modification of OLD Message-ID: <20191113030459.GB14545@momjian.us> References: <919823407.20191029175436@yandex.ru> <20191106185935.GE1843@momjian.us> <1771593631.20191107112032@yandex.ru> <352093181.20191107112429@yandex.ru> <20191107212655.GA487@momjian.us> <68E6C96E-45B4-428F-B482-AE0BAEC3DBEC@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <68E6C96E-45B4-428F-B482-AE0BAEC3DBEC@gmail.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Nov 11, 2019 at 07:00:22PM +0300, Liudmila Mantrova wrote: > > > 8 нояб. 2019 г., в 0:26, Bruce Momjian написал(а): > > > > First, notice "only", which was missing from the later sentence: > > > > For INSERT and UPDATE > > operations [only], the trigger may modify the > > NEW row before returning it. > > > > which I have now added with my applied patch to all supported releases. > > > > Hi Bruce, > > I happened to browse recent documentation-related commits and I didn’t see this patch in REL_12_STABLE. Judging by the commit message, it should be applied there too. Wow, not sure how that happened, fixed. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +