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 1reRBV-00BM4Z-29 for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Feb 2024 02:57:42 +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 1reRBS-009tGN-Lz for pgsql-hackers@arkaria.postgresql.org; Mon, 26 Feb 2024 02:57:39 +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 1reRBS-009tGF-8M for pgsql-hackers@lists.postgresql.org; Mon, 26 Feb 2024 02:57:38 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1reRBJ-0014Hr-Qp for pgsql-hackers@lists.postgresql.org; Mon, 26 Feb 2024 02:57:37 +0000 Received: from [172.30.0.166] (unknown [172.30.0.166]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: a.lepikhov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id B0CF1E20C3A; Mon, 26 Feb 2024 05:57:25 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1708916246; bh=RTU4OrJp6dK4JFP40qtp45O0Hc2eF3i9U7LQGBNxidA=; h=Message-ID:Date:User-Agent:Subject:To:References:From:In-Reply-To: From; b=wi+Iwdyzx7BRL3DhPLpyyfmCDAuzp8D+kQmYgF40+l46LiwUnm8ceqUWELekOHUgi vqCL4QahYPXoF6x97X+fxfclzbdYeIaVojETtVY7axX3wRmsDULOEjvl4hSXg90bK5 QkFCv35giWLIw31b1IMiN9h0J1ToEcFGJmOWh5la04ZaM+EPTLXMJ7NgCOLNJu5zL9 I3pmzWYJzAgTWtjKznoaJ0C+IeCnkKA/+UTjSqKbKLvG9jvjEOXgXwEDjp0yxfPG+4 DTT+MHJXIbelnoJaHYkvyGPyvSDN8KENGxm7MMJB51AMhVEG1MjDgDC6L2fCexkRdp Az4wVlh5OhK1g== Message-ID: Date: Mon, 26 Feb 2024 09:52:59 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: "type with xxxx does not exist" when doing ExecMemoize() Content-Language: en-US To: Tender Wang , PostgreSQL Hackers References: From: Andrei Lepikhov Organization: Postgres Professional 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 25/2/2024 20:32, Tender Wang wrote: > I think in prepare_probe_slot(), should called datumCopy as the attached > patch does. > > Any thoughts? Thanks. Thanks for the report. I think it is better to invent a Runtime Memory Context; likewise, it is already designed in IndexScan and derivatives. Here, you just allocate the value in some upper memory context. Also, I'm curious why such a trivial error hasn't been found for a long time -- regards, Andrei Lepikhov Postgres Professional