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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iUC7D-0002dH-Dg
	for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Nov 2019 16:00:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iUC7C-0004ZA-3X
	for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Nov 2019 16:00:30 +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 <l.mantrova@gmail.com>)
	id 1iUC7B-0004Yj-O9
	for pgsql-hackers@lists.postgresql.org; Mon, 11 Nov 2019 16:00:29 +0000
Received: from mail-lj1-x232.google.com ([2a00:1450:4864:20::232])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <l.mantrova@gmail.com>)
	id 1iUC78-0006Lw-8c
	for pgsql-hackers@postgresql.org; Mon, 11 Nov 2019 16:00:29 +0000
Received: by mail-lj1-x232.google.com with SMTP id g3so14351961ljl.11
        for <pgsql-hackers@postgresql.org>;
 Mon, 11 Nov 2019 08:00:25 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:subject:from:in-reply-to:date:cc
         :content-transfer-encoding:message-id:references:to;
        bh=uqgpZSC9gB5u3GV9pURSM70RAHhyjtWqNjTpd1PHx8g=;
        b=M9AXiR8Ds0MPD2czEqZNbKy3yF8HG9p/QkaSSpiGZkvU1SsfVKq4dOn6CkTSYfnjzz
         HYyGmSiOMdnS94BtCbsl77F75rpsMZcQ18dOK+FhIaGwM55g2VAxA7KUZgmMScpmAGrL
         SvCV0bjeXbUdYU9kGwNBdIe1ZGvCDuxyhQSlAbyUEQdxw46RWzyhec7DuozuOa+wI3Vj
         TqJb2KU7atS6/SEcIvGp8iomf3OY1xpcy9URlPotpfwUhV/RjvdOLS/4ybAeJG2c02yx
         oMn8WTG/OhtN4G6ivnxSCv/M90tu3FH/fKRfLoUja15HEMvodhQtKCK+zzhPJ0NoPbRc
         nBvA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc
         :content-transfer-encoding:message-id:references:to;
        bh=uqgpZSC9gB5u3GV9pURSM70RAHhyjtWqNjTpd1PHx8g=;
        b=IX1WnvWwPdEMDm7GSSK8zZZe9F6u9BLytkf6KxRM51sXJikjR9DdXTyxQ9GD0p6tzF
         g//SuDQO/ia35RQOGbVrniP+TEoXNnXQcrOHIjRBAGWhtc3M4f278Xk1R2kW+Coe8hCu
         fCiKC0EPjjHMaulLU3vN08BG55+AOcuHx4E54ygqnKD5YGEHC8qSWkSC/46SuccuaOoc
         cf/0LReN8/eCfKShEVE2iqkryf4sObbKsPY0ze6SC40cuVyDiUeFw0sDj1naq+dQYj6Y
         58Mh6GibUKTTcwK84VW4YeNnDG3wpV8U+xU88sxYy+Frb9LcWL/bShQSnRKJN0jwn0Yh
         YkKg==
X-Gm-Message-State: APjAAAW0+vzutZ7YDfNv1Lh8rJoI5l16PRjFKfo4JvNqmAEcSSB1qBIT
	3ZgRLxlxoGVgucCYVJMkWztwwVpmbQU=
X-Google-Smtp-Source: 
 APXvYqzAV4XLvRmRWzAW8wtZ1n0WKcgj8BfqDE/GJKqyDGXIax61wf0TN3p+OMvFb/CByFUArM13JA==
X-Received: by 2002:a2e:7c12:: with SMTP id
 x18mr17054929ljc.130.1573488025018;
        Mon, 11 Nov 2019 08:00:25 -0800 (PST)
Received: from [100.117.42.187] ([31.173.84.125])
        by smtp.gmail.com with ESMTPSA id
 g14sm310178lfj.17.2019.11.11.08.00.23
        (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
        Mon, 11 Nov 2019 08:00:24 -0800 (PST)
Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (1.0)
Subject: Re: Does 'instead of delete' trigger support modification of OLD
From: Liudmila Mantrova <l.mantrova@gmail.com>
X-Mailer: iPhone Mail (16F203)
In-Reply-To: <20191107212655.GA487@momjian.us>
Date: Mon, 11 Nov 2019 19:00:22 +0300
Cc: Eugen Konkov <kes-kes@yandex.ru>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>,
 pgsql-docs@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <68E6C96E-45B4-428F-B482-AE0BAEC3DBEC@gmail.com>
References: <919823407.20191029175436@yandex.ru>
 <20191106185935.GE1843@momjian.us> <1771593631.20191107112032@yandex.ru>
 <352093181.20191107112429@yandex.ru> <20191107212655.GA487@momjian.us>
To: Bruce Momjian <bruce@momjian.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk


> 8 =D0=BD=D0=BE=D1=8F=D0=B1. 2019 =D0=B3., =D0=B2 0:26, Bruce Momjian <bruc=
e@momjian.us> =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
>=20
> First, notice "only", which was missing from the later sentence:
>=20
>    For <command>INSERT</command> and <command>UPDATE</command>
>    operations [only], the trigger may modify the
>    <varname>NEW</varname> row before returning it.
>=20
> which I have now added with my applied patch to all supported releases.=20=

>=20

Hi Bruce,=20

I happened to browse recent documentation-related commits and I didn=E2=80=99=
t see this patch in REL_12_STABLE. Judging by the commit message, it should b=
e applied there too.=