Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1m8W9l-0005RE-ON
	for pgsql-novice@arkaria.postgresql.org; Tue, 27 Jul 2021 23:06:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1m8W9k-0005Ad-JH
	for pgsql-novice@arkaria.postgresql.org; Tue, 27 Jul 2021 23:06:36 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <mitchelln@posteo.net>)
	id 1m8W9k-0005AU-Ch
	for pgsql-novice@lists.postgresql.org; Tue, 27 Jul 2021 23:06:36 +0000
Received: from mout02.posteo.de ([185.67.36.66])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <mitchelln@posteo.net>)
	id 1m8W9i-0008OH-B0
	for pgsql-novice@lists.postgresql.org; Tue, 27 Jul 2021 23:06:35 +0000
Received: from submission (posteo.de [89.146.220.130])
	by mout02.posteo.de (Postfix) with ESMTPS id B23AB240101
	for <pgsql-novice@lists.postgresql.org>;
 Wed, 28 Jul 2021 01:06:31 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017;
	t=1627427191; bh=pQENx8CJB2N71YPrmwZlXm3y4aSOa+Dnib6GxiQMNUU=;
	h=From:To:Cc:Subject:Date:From;
	b=dHMNCmTzpYQqjtWS2iT64HMJotopPIFN+qPFxO+JPQ09ARigM0V1X7CipuHE+4FM8
	 /xGvjaSyDUKXAc5oLHaCrP6hZBtgNynunCZ2f4GaxzYuWdFh/VF7tUyr7sd2sJPaWg
	 6pEFdXrku+Nv9MLSyEUI3WgumEeoWwYQ9CADypwYJKOGEm20MnLIX0pCiSEWcLlQJh
	 npr5w4bBlzeEgqpX7xOVTGiuKqyhi7osCteSAcJR07DSr3wz5bVS45TYr3JRutKSc0
	 H/iweSTqXYnaexZ2iEnGDMUWdkoGHN/q5Jg2V9tiQRvHEvaK+6RJ9UWj2Vqb+ec/M4
	 yaD790xFNvMLQ==
Received: from customer (localhost [127.0.0.1])
	by submission (posteo.de) with ESMTPSA id 4GZC8k36z7z9rxK;
	Wed, 28 Jul 2021 01:06:30 +0200 (CEST)
From: "Nicolas Mitchell" <mitchelln@posteo.net>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "hubert depesz lubaczewski" <depesz@depesz.com>,
 pgsql-novice@lists.postgresql.org
Subject: Re: Trigger function
Date: Tue, 27 Jul 2021 23:06:29 +0000
Message-ID: <719F5BCE-DC7E-4791-BD82-3CA6A381F84C@posteo.net>
In-Reply-To: 
 <CAKFQuwbK=eOoognbSWjJXn-B7c2X_8HH6K2pn3amH3A7oD0JFA@mail.gmail.com>
References: <30B8A3D0-8A87-40E2-BE40-31A17BA4B944@posteo.net>
 <20210727063805.GA28983@depesz.com>
 <2D1DF30A-25BC-48CA-B502-D8B3147B9BEB@posteo.net>
 <CAKFQuwazmQBDYdt+zcw2WV+3bONRjbe7qoHiMnREYj+VRXEXjA@mail.gmail.com>
 <CAKFQuwbK=eOoognbSWjJXn-B7c2X_8HH6K2pn3amH3A7oD0JFA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/719F5BCE-DC7E-4791-BD82-3CA6A381F84C%40posteo.net>
Precedence: bulk

On 27 Jul 2021, at 23:15, David G. Johnston wrote:

> On Tuesday, July 27, 2021, David G. Johnston <david.g.johnston@gmail.com>
> wrote:
>
>>
>> When you write a trigger for a table you should be executing commands
>> against the same table.
>>
>
> Should [NOT] be executing [data changing] commands against the same table.

Crumbs, but thank you. Digesting now.

Nic