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 1sp7jq-00GmPr-Os for pgsql-general@arkaria.postgresql.org; Fri, 13 Sep 2024 14:57:35 +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 1sp7jq-004Zt1-E1 for pgsql-general@arkaria.postgresql.org; Fri, 13 Sep 2024 14:57:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sp7jq-004Zsb-3M for pgsql-general@lists.postgresql.org; Fri, 13 Sep 2024 14:57:34 +0000 Received: from fout3-smtp.messagingengine.com ([103.168.172.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sp7jm-0010Rq-76 for pgsql-general@lists.postgresql.org; Fri, 13 Sep 2024 14:57:33 +0000 Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51]) by mailfout.phl.internal (Postfix) with ESMTP id 362EF138024B; Fri, 13 Sep 2024 10:57:30 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-11.internal (MEProxy); Fri, 13 Sep 2024 10:57:30 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1726239450; x=1726325850; bh=M4ICorg1ZGPYcBPa4InBl1uRjTcJ17wjRmSe4CjelJ0=; b= LASFIflKee5I+pb0UH+gtsgCQkaoG6XNNd3h8WYmvi5WtzlAp7FxvmUNjIcGRy5K NXL628DF5erNJSRiX2Fj94sjFWQpjPYJC4EwKfaMJZN3YpQXgMbedPpSo4Q180P+ xgZJiWsDWoKnzvDZZwXHC2XWodyAizG2ikbTPcnOrvkMYrLDstw0Onsg+XMt1lDH 01Wku6DKQNt9NxJjQZJpRFvHYQeGFwHfdJ54d27wAG2QImNeEGKQk+cdT3tL7FCS 2RAmn8p1YGVKyt3SR61QT4LFf5TYsSd53d5BFtMRqJoy0lDAfz0j7qSJasqxfEXp zy/FdFsLmc3uugIOwxAlfg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1726239450; x= 1726325850; bh=M4ICorg1ZGPYcBPa4InBl1uRjTcJ17wjRmSe4CjelJ0=; b=e kd2hE4uYzbOkBcDfinonFnSeMRCW305InTz0ROOg9Ev9fFQQyvkZjwHZ+X/QFzFP W237jpNWApcIYdIMDvJ+1cTqQxU3si0uTa3T2b4x82MMYIb3W1q2RYyuw8Vdo+c5 0YOXCmt+443AVk6QKjHcHA7Ae19OrX/souuZpJjDXfQiOgkhlZkc8dGcmnOw4TC8 Hnx7DpGW7zVl2uWbYzayQquM+FdksVOnC7Dox0MJ5fFP7y9eeoa8TfNNuHC/NNER AMhMQw9YUJrds3R0lRoWno9qVtmsTzMGIHQKDzhQ+y4duYxSqvFl13fmr8WYT2z1 nCU5vUWfFW3apfZyuXOfg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudejjedgkedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffhvfevfhgjtgfgsehtjeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepveeftedutdehfefggeel tdevleevgeffjeeivddtteeivedtjeefudetiedtudefnecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpd hrtghpthhtoheprhhoughrihhgohgsuhhrghhoshhmvghllhgrsehgmhgrihhlrdgtohhm pdhrtghpthhtoheplhgvrghrnhgvrhgurghtrggsrghsvgelleesghhmrghilhdrtghomh dprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsthhgrhgv shhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 13 Sep 2024 10:57:29 -0400 (EDT) Message-ID: <67f2a664-b480-40ea-892d-2ab2147ad390@aklaver.com> Date: Fri, 13 Sep 2024 07:57:28 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Manual query vs trigger during data load From: Adrian Klaver To: Juan Rodrigo Alejandro Burgos Mella , yudhi s Cc: pgsql-general References: Content-Language: en-US In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/13/24 07:50, Adrian Klaver wrote: > On 9/13/24 02:58, Juan Rodrigo Alejandro Burgos Mella wrote: >> Hello, I find it unlikely that the trigger will work properly, since >> the reserved fields of the OLD subset have no value in an INSERT > > I'm not seeing that the OP is asking for OLD.* values, they are just > looking to include the result of a lookup on another table in the INSERT. My mistake I see the OLD reference now. > >> >> Atte >> JRBN >> > > -- Adrian Klaver adrian.klaver@aklaver.com