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.96) (envelope-from ) id 1wNACH-000cWh-26 for pgsql-hackers@arkaria.postgresql.org; Wed, 13 May 2026 14:04:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wNACG-009A4Z-0y for pgsql-hackers@arkaria.postgresql.org; Wed, 13 May 2026 14:04:24 +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.96) (envelope-from ) id 1wNACG-009A4R-08 for pgsql-hackers@lists.postgresql.org; Wed, 13 May 2026 14:04:24 +0000 Received: from forward100a.mail.yandex.net ([178.154.239.83]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wNACD-00000000PPy-2JCH for pgsql-hackers@lists.postgresql.org; Wed, 13 May 2026 14:04:23 +0000 Received: from mail-nwsmtp-smtp-production-main-64.vla.yp-c.yandex.net (mail-nwsmtp-smtp-production-main-64.vla.yp-c.yandex.net [IPv6:2a02:6b8:c18:31e:0:640:f144:0]) by forward100a.mail.yandex.net (Yandex) with ESMTPS id A7F4BC03CA; Wed, 13 May 2026 17:04:20 +0300 (MSK) Received: by mail-nwsmtp-smtp-production-main-64.vla.yp-c.yandex.net (smtp) with ESMTPSA id H4MeRrISKSw0-QXdsJhdy; Wed, 13 May 2026 17:04:20 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1778681060; bh=snqPGPU9s3NxCPyUncyoXeb4HmVeXFtBeZqrzm2d47s=; h=In-Reply-To:Cc:Date:References:To:From:Subject:Message-ID; b=CSO+wrhCit+YlAXTrZwiM6f/Eg713RulwcyMs5Mze5qFOKnChje6cgOTOmFPX/YHh MJ6jaYboZ2Mav43/Q8W32GvdXY9DNRVN3doROJDOrqhUtCSd80gy5TzbD7/XHGSOxJ N3a27KXOeOMkOu35ckIm0BKfz1T+eaE206opcb2E= Authentication-Results: mail-nwsmtp-smtp-production-main-64.vla.yp-c.yandex.net; dkim=pass header.i=@yandex.ru Message-ID: <7ed875f5-6ca4-42ff-8518-8af8da5115fb@yandex.ru> Date: Wed, 13 May 2026 17:04:18 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pull-up subquery if JOIN-ON contains refs to upper-query From: Alena Rybakina To: Peter Petrov Cc: Ilia Evdokimov , PostgreSQL Hackers , Ranier Vilela , David Rowley References: <0b1f670d-b39d-4966-bf32-f0d502ebc564@postgrespro.ru> <46bc4eaf-58c5-42ab-8041-d3380a0768de@postgrespro.ru> <9b041978-06e3-4a50-8a5d-dacbb054f23e@tantorlabs.com> <8d7cbbf6-ddc0-4696-8af2-a68d740e14f2@postgrespro.ru> <6078f7e1-4b29-4b31-bd28-b84149e404e4@postgrespro.ru> <975a3736-a8b5-49b3-8009-4d4e86867aa1@postgrespro.ru> <0adbf75a-2059-4bb7-b878-c33892dbc1f0@tantorlabs.com> <300d7bb0-345c-4c0b-a0ef-4de573fcc94b@postgrespro.ru> <32446f52-1b18-499a-a77b-d6b66ad0f4cf@tantorlabs.com> <87a6fcbf-929a-408a-9471-28be3080254a@postgrespro.ru> <4e9d279c-83c1-42d3-b74d-7366ecd7f085@tantorlabs.com> <0c498546-8af0-4aec-98fa-ad4f373cf711@yandex.ru> <0686b354-57dc-46e9-b756-21661c656c10@yandex.ru> 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 13.05.2026 16:51, Alena Rybakina wrote: > Hi! you are discussing it out of thread - I warn you just in case. > Sorry for not replying on your email, I have noticed it now only. > Sorry, it was my mistake - the app shows participants in the discussion incorrectly - skipped PostgreSQL Hackers . Everything is fine. I'll go back in few days with feedback and updated version of the parch -- ----------- Best regards, Alena Rybakina