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 ) id 1pPmdy-0001He-Aq for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Feb 2023 15:45:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pPmdx-00079W-7I for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Feb 2023 15:45:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPmau-0001oe-GX for pgsql-bugs@lists.postgresql.org; Wed, 08 Feb 2023 15:42:48 +0000 Received: from mail.indevlab.com ([116.202.37.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pPmar-0008W3-Ni for pgsql-bugs@lists.postgresql.org; Wed, 08 Feb 2023 15:42:47 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.indevlab.com (Postfix) with ESMTP id 8515EBC75D63; Wed, 8 Feb 2023 13:42:44 -0200 (-02) Received: from mail.indevlab.com ([127.0.0.1]) by localhost (mail.indevlab.com [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id m8OA67JB9KMV; Wed, 8 Feb 2023 13:42:43 -0200 (-02) Received: from localhost (localhost [127.0.0.1]) by mail.indevlab.com (Postfix) with ESMTP id DC7BFBCD8D58; Wed, 8 Feb 2023 13:42:43 -0200 (-02) DKIM-Filter: OpenDKIM Filter v2.10.3 mail.indevlab.com DC7BFBCD8D58 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=indevlab.com; s=2BB9513E-7140-11E7-B94A-EFF73A7DAAA4; t=1675870963; bh=6Cd8yK6zGO4qvTK14srEDUdi/F3QiI9SgCnfeCqEonQ=; h=Date:From:To:Message-ID:MIME-Version; b=o1Btk7B45WHG+/wQ55+IVp8tQrNiVqZYeIEovhYTo7qbzdvRFL3XwgpsRrp/qfT9V 5w9hZHZQQ7eRszrxebww/WoIAfzt869mieJiVWf1yIFN/Ro3dhplWY6i4b0uHuPGJc 8VGDEWA6LRYokNVEPSI7s7ituBGLgAcOU7IO3XquzLpk7qtXTcoRDSrzsdQJWx4wxe STgAkAeSpEJ7cspDtFvq4ndiY6MmJ9KHu25LVOAvNlvIKczQbdY8QJAdRfpksPZ9WQ RgiosTN+iViQsEt4o6hepQWZGLCMsAHLnQV+jX0l+pnMPPpM39/ynH4bz/XrHLI5zc 8FxYHxv/0SLnA== X-Virus-Scanned: amavisd-new at indevlab.com Received: from mail.indevlab.com ([127.0.0.1]) by localhost (mail.indevlab.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id sUgTZ2eGtQJq; Wed, 8 Feb 2023 13:42:43 -0200 (-02) Received: from [192.168.1.38] (unknown [194.44.96.87]) by mail.indevlab.com (Postfix) with ESMTPSA id 952EEBC75D63; Wed, 8 Feb 2023 13:42:43 -0200 (-02) Date: Wed, 8 Feb 2023 17:42:37 +0200 From: Dmytro Hanzhelo To: pgsql-bugs@lists.postgresql.org, "David G. Johnston" , Alex Bluce Message-ID: <8fceb0e9-de0b-42b9-b12b-e3d6b32332ba@Spark> In-Reply-To: References: <17782-23a2f2a4c868a72e@postgresql.org> Subject: Re: BUG #17782: ERROR: variable not found in subplan target lists X-Readdle-Message-ID: 8fceb0e9-de0b-42b9-b12b-e3d6b32332ba@Spark MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="63e3c2f2_216231b_4c1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --63e3c2f2_216231b_4c1 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline We can't send the dupm to mailing list for security reasons, please provi= de an e-mail address to send dump personally. =E2=80=94=E2=80=94=E2=80=94=E2=80=94=E2=80=94=E2=80=94=E2=80=94=E2=80=94=E2= =80=94=E2=80=94 Best regards Dmytro Hanzhelo CEO at InDevLab On 7 =46eb 2023, 15:44 +0200, David G. Johnston , wrote: > On Tue, =46eb 7, 2023 at 6:38 AM PG Bug reporting form wrote: > > > The following bug has been logged on the website: > > > > > > Bug reference:=C2=A0 =C2=A0 =C2=A0 17782 > > > Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Dmytro Hanzhelo > > > Email address:=C2=A0 =C2=A0 =C2=A0 d.hanzhelo=40indevlab.com > > > PostgreSQL version: 13.9 > > > Operating system:=C2=A0 =C2=A0CentOS Linux release 8.3.2011 > > > > > > > > > UPDATE corestatus.system=5Fmodule > > > SET state=3Dtrue > > > WHERE module=5Fname=3D'cfront=5Fexchangerate'; > > > ERROR:=C2=A0 variable not found in subplan target lists > > > > > > We can provide dump for reproduce. > > > > Then do so - because without a reproducer it is going to be difficult= to observe the behavior to fix this. > > > > David J. > > --63e3c2f2_216231b_4c1 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
We can't send the dupm to mailing list for security= reasons, please provide an e-mail address to send dump personally.
=

=E2=80=94=E2=80=94=E2=80=94=E2=80=94=E2=80=94=E2=80= =94=E2=80=94=E2=80=94=E2=80=94=E2=80=94
Best regards
Dmytro Hanzhelo
CEO at InDevLab
On 7 =46eb 2023, 15:44 +0200, David= G. Johnston <david.g.johnston=40gmail.com>, wrote:
On Tue, =46eb 7, 2023 at 6:38 AM PG Bug reporting form <noreply=40postgresql.org> wrote= :
The followi= ng bug has been logged on the website:

Bug reference:&=23160; &=23160; &=23160; 17782
Logged by:&=23160; &=23160; &=23160; &=23160; &=23160; Dmytro Hanzhelo Email address:&=23160; &=23160; &=23160; d.hanzhelo=40indevlab.com
PostgreSQL version: 13.9
Operating system:&=23160; &=23160;CentOS Linux release 8.3.2011


UPDATE corestatus.system=5Fmodule
SET state=3Dtrue
WHERE module=5Fname=3D'cfront=5Fexchangerate';
ERROR:&=23160; variable not found in subplan target lists

We can provide dump for reproduce.

Then do so - because without a reproducer it is going to b= e difficult to observe the behavior to fix this.

David J.

--63e3c2f2_216231b_4c1--