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 1wFpOq-005b7O-0c for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Apr 2026 08:27:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFpOp-000mr6-15 for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Apr 2026 08:27:03 +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 1wFpOp-000mqy-0D for pgsql-bugs@lists.postgresql.org; Thu, 23 Apr 2026 08:27:03 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wFpOn-00000002cMp-0joV for pgsql-bugs@lists.postgresql.org; Thu, 23 Apr 2026 08:27:02 +0000 Received: by mail-ej1-x62b.google.com with SMTP id a640c23a62f3a-b9c3e2cf3c0so1130836766b.1 for ; Thu, 23 Apr 2026 01:27:01 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776932820; cv=none; d=google.com; s=arc-20240605; b=eJccUkBCg+aFDFXFwV/sIt5flkmocz1OWtF12fdVVyuKiScDgEGqPDQ9enkZV83D9B BuCWG6PbHS6hQ1bOwoCxoMS+CH7Ltp/8HVVETZpbvVjdlA5GyzXsomK5QgQYZwsps3ey NOwBspc3Mtp2kDkY4AqzykoxgyVhthutEqcIECpk2K8KEsyUtXFvSWphhUb+yb036ome RcSplQp3DBgwNDnvYklstSha0kfjaIbQ6f8Vy6SX43B3vpwvz9pIY+5rI2aiiKCU50WT 1TrB0cHtkPhWb5FIVWbBPTJHN0brJvtuLm33EEkGjToRmME/fJvmr1XkSYzrIO+DTG2I zj5g== 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=6d4Pz3P/Wp6ninabDNmLCh5CTbkRc9e3hwwIP2CAqTM=; fh=j3740692OFZfC2CbkxwfQamSAzOxL/pdvgGZb1zCzPk=; b=MQ6zpnhHygaFllT95sytUtRz1LZbWZly7nm0dVB+5K05S4n78F9Tv9BDosVrg1j8iL SXDBFi3hadHqAHJ/6+nPlJ+OFe7J7mluX2c3r0RvRGa5nvjRp83KjtUJo+VftvbkYCI6 jbCyHC1M1LaVgssFmTQ7smb1fe+s8lfP41kzdekuifCKL8UkxPn7Ro6c3FbMaVV/dHVE SJZz+6z8IuEOp1gEB+fCuVecR6mQTl2PU3PY5PT3WuLcyzYfwYq0teIvWLAvu9LowaKK 9naqWJl8dL8dK8VWlGS/hyWPD1NdmbzK1XdV279KS2q3ctLPokEbubAsQ5cL74YPC9mY tfDA==; 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=20251104; t=1776932820; x=1777537620; 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=6d4Pz3P/Wp6ninabDNmLCh5CTbkRc9e3hwwIP2CAqTM=; b=WF9+DWlU8RMxcpp2UlnKaC98impA8MH4tMDOOh0ZyIh0AiO7iyip8sGOCX0gw32pnM FIna1tAZf2RPnYmi2ss4epCtGiiFTRtyK/kaoILcIQeE4fc6dcGo3vXGbA+nmCSsRYko xCBQjYiOzf+Q757jsTzjOiuBV4/q1fFehekQIv9QjykppxY7+/LgjKyxusLLMVbY1ANd 98Y1sqJAzHUOrh7qY60xPTwgp8YcUSxMfgZQ3Lepqqz7MzC7Uf6TBd4NP9WEh3+bCi7r zFuuknPMDVoZzfpey61oeffbVc+B/fxCIhnD/NKSq4+IgRPhkb+YmXB7WfQM5SCACAEr vX9g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776932820; x=1777537620; 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=6d4Pz3P/Wp6ninabDNmLCh5CTbkRc9e3hwwIP2CAqTM=; b=VnNtIBaO0rTkYNIBWLfjsQP2U0PLh+MQP6ym1I+6kSsyjRd+FG6yvP20GxZsDmJq4k Br/OCOPebSthsHhr21HNeFrxzmDhisFAW5rmzZM60BiaVDvOSFIpfjQDSd057hnk6VTu NR/sbJdH/dIb94e+JLnWb4vw9as9TZMSh1aZ48OEQr5h22cn1VeQvHZXiK6UTeW5pOtM PJCd/RT115JMoRrZjDLNMhLIDSOSNwffB5kRY8hLi1G3f5H9PLg3vsWeh4IlSfmhsiAZ hLidHH8jIp+5KAYL/5hx5E5qeQGSrOfNMwEgSLvnpsEfu/AOaKpwLxQDANrg0+mRf9Th gpRg== X-Forwarded-Encrypted: i=1; AFNElJ/hNXTJXeFgqgLREoQgHEL/6eWfXeGWx9ntk9GDsc2izi8pU15ZSL1Fscfi8ctE0ai5YIbNQ6G38u3u@lists.postgresql.org X-Gm-Message-State: AOJu0Yw1dPy3k1J+ciMrFp6tyo/cC7YATIJR3Qglk4P4s8leblbQ7Mlb 4UDI1e1bxdAjJdiq+ow8Jwv9QyybXhd5oDrpW2Y33BXw3pvL/yA7uQHq2bNNjhY6ASJaHoeHXje fmk4UaAoXkxBL+aXzHIPDuayMWl9Qgvw= X-Gm-Gg: AeBDievVnmw10GbimlZSTa8Bg24a3jajkYQ+Afn+Myttb9RPWR5QfMJnyyibpxQH5ML SzdAE8ikXZ/lCdFuHznFJukGdOR7a4e4SdSe7EVUikrjjn9iMUmJdCVES8fF3SkFznLC+Y3WEmd ARunUR+3wNb42hKp2Ct2fH1L83uSpaNaqDAsVfL6hNvrm9819FcYZVIVyFwEbLyFcPyZwm6d+xZ GVNwgRtmo3ftwl0bTXlxNlknVgGGiYVoT3K2FFH+et1gwuY2CGZtqcG87fWtO9so72nfnpaguf0 /7wAjRyNvFBKP7GtbFNMrDbAsVZybWrHF0f8IAYeokbKZ1Qu7/qjZ1yG51nG77jEunE= X-Received: by 2002:a17:907:3da1:b0:bab:9111:b447 with SMTP id a640c23a62f3a-bab9120f8cfmr240038266b.24.1776932819887; Thu, 23 Apr 2026 01:26:59 -0700 (PDT) MIME-Version: 1.0 References: <19435-3cc1a87f291129f1@postgresql.org> <5a039d60-d13b-4cf0-a807-9c7269f06831@gmail.com> In-Reply-To: From: Tender Wang Date: Thu, 23 Apr 2026 16:26:48 +0800 X-Gm-Features: AQROBzBwAw-qD7cnaryCiTCT14Do95TgkSkQ4a8Zzu6B3MrXsX7QmE9Plks2H10 Message-ID: Subject: Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables To: Alexander Korotkov Cc: Andrei Lepikhov , Kirill Reshke , 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 Alexander Korotkov =E4=BA=8E2026=E5=B9=B44=E6=9C=882= 2=E6=97=A5=E5=91=A8=E4=B8=89 23:10=E5=86=99=E9=81=93=EF=BC=9A > > I have another approach about to deduplication of RestrictInfo's. The > field, which differs in this case, is outer_relids. AFAICS, > outer_relids and incompatible_relids serves as the restriction on what > we can do with RestrictInfo. So, what we can do is to ignore both > outer_relids and incompatible_relids during comparison, but compose a > union of their values for remaining RestrictInfo. That means that > remaining RestrictInfo will ancest all the restrictions, and that > should be safe. > > What do you think? It seems workable and safer than the previous solution. --=20 Thanks, Tender Wang