Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnOVj-00Anlv-3K for pgsql-general@arkaria.postgresql.org; Mon, 02 Oct 2023 19:23:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qnOVg-00Gw2Y-4D for pgsql-general@arkaria.postgresql.org; Mon, 02 Oct 2023 19:23:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnOVf-00Gw2L-OP for pgsql-general@lists.postgresql.org; Mon, 02 Oct 2023 19:23:15 +0000 Received: from janus.karlpinc.com ([173.161.46.12] helo=smtp.karlpinc.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnOVY-007q7w-Q0 for pgsql-general@lists.postgresql.org; Mon, 02 Oct 2023 19:23:14 +0000 Received: from slate.karlpinc.com (unknown [192.168.1.14]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by smtp.karlpinc.com (Postfix) with ESMTPS id 73574A219; Mon, 2 Oct 2023 14:23:06 -0500 (CDT) Received: from slate.karlpinc.com (localhost [IPv6:::1]) by slate.karlpinc.com (Postfix) with ESMTPS id EFFE13FD6B; Mon, 2 Oct 2023 14:23:05 -0500 (CDT) Date: Mon, 2 Oct 2023 14:23:00 -0500 From: "Karl O. Pinc" To: Tom Lane Cc: pgsql-general@lists.postgresql.org Subject: Re: Trigger functions and parallelism Message-ID: <20231002142300.59b3387e@slate.karlpinc.com> In-Reply-To: <2128653.1696266439@sss.pgh.pa.us> References: <20231002114942.56a6f656@slate.karlpinc.com> <2128653.1696266439@sss.pgh.pa.us> X-Mailer: Claws Mail 3.17.8 (GTK+ 2.24.33; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 02 Oct 2023 13:07:19 -0400 Tom Lane wrote: > "Karl O. Pinc" writes: > > What I'm looking for is some general statements about > > parallel safety for trigger functions. I don't know > > enough about parallelism to even know if it applies > > to data modification statements. > > It doesn't, which is why the docs are silent on the point. Thanks. Regards, Karl Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein