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 1w2UVh-000L1t-1R for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Mar 2026 13:31:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2UVg-001Xnj-0i for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Mar 2026 13:31:00 +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.96) (envelope-from ) id 1w2UVf-001Xna-2h for pgsql-bugs@lists.postgresql.org; Tue, 17 Mar 2026 13:30:59 +0000 Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2UVc-00000000Bq2-2zlI for pgsql-bugs@lists.postgresql.org; Tue, 17 Mar 2026 13:30:58 +0000 Received: by mail-ej1-x632.google.com with SMTP id a640c23a62f3a-b9789425fc5so104739866b.1 for ; Tue, 17 Mar 2026 06:30:58 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773754257; cv=none; d=google.com; s=arc-20240605; b=fveBOg4RTfoUhU4lq4wPExGnvxPOXnQbCfuQ3WeSmRpH3fpzqfugRdxW8ss2C7JE2u ZsYoOnkRSJCZL4L6AL27FJdbb44OBsIiXa71rb3nWM0tEL1z+RnV4MfEJSFcG58xGTqj zgWONa9C4PTOVS3AtYbH/eYR0Euh+gJEnr480M3aiQfUc5g8jxqVm6mocSJhpN69uBBD povIhmoXkPqtTjVKFAXJmfSqobwtHtsOn/2G/JhwFNO/Miwf5pnsirEYobeejmx8cwgl HhqgnANKlc+3DQg3r+aChukSg9ZnaVAg5x+jj5KWjEvafvQdFOujwFaGCQyUDgx6fCAe /GyQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=cuJaUaGQHVb9NkvxOR89ACTvKvgHPfLLuBDwGuvlQ+w=; fh=bCEG2VHVKJiP7OKVBoHHBeyofR5C07yTm0RJkziIu8k=; b=Joto9TvGeOH6DbSrZUbWzqHY0Bum1a4SFlVA+Ml5gnra7uTFHZbV06aqBXcKVq6pRL BvUKuSDqJVCSus4xcFzgEg1ktPAVA6LcqQlVRwAtK7BPybpp22OT9C1d8Zz3mhgbQDtB vgYRAX3+enPinoVzug91UQ0Q7r7I/d2yIY2GwmEtMXZ2zVXDmJjLOZyiM29p0RjxTV/G SyqyFnbw5WW1QNTz3WJTDXdzgVpGojxJ97q2D/lbfk1AS8+ZF3yG3jnJu7/c0P9byWLT VG8k3LcHJt/hpovM5NfG0cDZkyt59LWiTW1Ay95pomIBkWuZoE1WtvBT7e5+13fXUAMt gb8Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773754257; x=1774359057; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=cuJaUaGQHVb9NkvxOR89ACTvKvgHPfLLuBDwGuvlQ+w=; b=Axd/Ga7bEI0aVESuFHOw802Uoed9pnsEwwU77/x37X3AS3rxsVp4Uqk/GTZ9DcFxC2 wZ3pKWK4QyJs3xTxmq+EvSquv3g/LwxVRAgcicGdk8cj67Rq8WQxAvLIF7DleS1ztSu9 FxW/8jpSGu/PbS36s84hWWntcvXXvtei5/zDN8OsYNorBSE7x9xdVxplD+z8pR8gH4XD MFyPUcAjUME5QwNFbOaAPP3Zy0CQBEx4U47VrUAlKkhrQpQ71LgJUa+Q6skgN/gpa4yu bTBSCo23Oyb65b2EzYEo6cII5uHJy6gFxJNR1NgC+vjNPUJH8AyuGzSN8PyN3s81Wb5c 0PXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773754257; x=1774359057; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=cuJaUaGQHVb9NkvxOR89ACTvKvgHPfLLuBDwGuvlQ+w=; b=WvWjqT8SV2LB0XWtrBocZef+Y0CD2ru3jcUkHsQDRiHEiclgExQszCQiXUUx+p9cYb Idu6UEL9bRuy315MLk1EVWBg9sHv+gvAC7qHZZufk5ZlU0F+bVHtrexaFFswGInQ7z1g WWQxDw2GxOWuvose+HAEbs8P+6joqW4Jh9aclHlTEa9WzRH5RKF6jQrlR4VJwwh2hayO B1ozZJZvW8yXuUV+nHNK7vVBXTSUVkqXF1rardyYcj7ZdazPmdbP6eutqGe85cnNjZ1Y tp8N8WS3Fra75XNezZ2TSWaCYlVlC7BI/UIbrxC362ut7uMpg7Mm11sR7ZkKitFuBuTF c05g== X-Forwarded-Encrypted: i=1; AJvYcCU1Y4mch3P+4a5YNiZc81V8Mr7Xqu4rmhaZ1S3YK/PFT5TGTN+grzVIrVFNgL1EFyPRpZcq8LzHGV8C@lists.postgresql.org X-Gm-Message-State: AOJu0YzBaR2QlY22BTwR88kjpMy1CITrqTLCCO88Vw7PHDDfhkIdml9n OAr8zl9ZNJ/fU39VUCwCH8d5OUvA2WJNjt8S6kTaltKoEaylK6ABf6778P+a6sRCR5jOCAq8pkl LM/2L6kNi8J1UsuKoO+IZ7DYMq2TZRR0= X-Gm-Gg: ATEYQzxzVUBq8930PxboGpXLbIxe73r0xAyuR4AMaLtc+rNbCQ3NqrUd53LvOZhsUrl EatyEmJ9H6kicwJ04MucWkX2Xz8N6lEBcONXvej5py+dOxRO1H7woRXwYDvi8feeRpTpeZm67xP YeF4ypnWtzNtV8aht89LAoJJQktrvKAY7jw9krc7S/0wNPU8bcvw59Jh+Nx4FUvfYxAHhMtzCKA yTpPVFkL2xJk54bZjrVuoP6g7EAVjOaue8+Mu8y7r9lXqgXOFhuTCUnEa7/IxxVcqQjLpfqRjPO R+5al4c= X-Received: by 2002:a17:906:f59e:b0:b96:f0a0:c7b1 with SMTP id a640c23a62f3a-b97d6c0df7bmr225433466b.2.1773754256640; Tue, 17 Mar 2026 06:30:56 -0700 (PDT) MIME-Version: 1.0 References: <19435-3cc1a87f291129f1@postgresql.org> In-Reply-To: From: Tender Wang Date: Tue, 17 Mar 2026 21:30:44 +0800 X-Gm-Features: AaiRm51RaiMyEYrsebS6TIiVrlgLFMLSR2Ca5tdNckbjq8_9e2iNxaqmiJyXYco Message-ID: Subject: Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables To: Kirill Reshke Cc: Alexander Korotkov , Fujii Masao , ammmkilo@163.com, pgsql-bugs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Kirill Reshke =E4=BA=8E2026=E5=B9=B43=E6=9C=8817= =E6=97=A5=E5=91=A8=E4=BA=8C 21:24=E5=86=99=E9=81=93=EF=BC=9A > > On Tue, 17 Mar 2026 at 18:20, Tender Wang wrote: > Yes, it looks like your analysis is valid. Will you share a patch for > updating `clause` ? > Sorry, it's already the middle of the night here, so I'm afraid I don't have much time to work on this right now. --=20 Thanks, Tender Wang