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 1w4cQJ-002N84-27 for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 10:22:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4cQI-00Gx3Z-0O for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 10:22:14 +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 1w4cQH-00Gx2g-2T for pgsql-hackers@lists.postgresql.org; Mon, 23 Mar 2026 10:22:14 +0000 Received: from mail-dl1-x122e.google.com ([2607:f8b0:4864:20::122e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w4cQG-00000000bkH-16b9 for pgsql-hackers@postgresql.org; Mon, 23 Mar 2026 10:22:13 +0000 Received: by mail-dl1-x122e.google.com with SMTP id a92af1059eb24-126ea4e9694so6741072c88.1 for ; Mon, 23 Mar 2026 03:22:12 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774261331; cv=none; d=google.com; s=arc-20240605; b=kn8Rzy/Mp9njDXJXjbNriQjUnNQ7SRyxGFx34yr/0dXaeviHmOS0GFJaP/VkorWTkO WBr/sVlADkAO6VR9Vhg5CB7D0x86HYsdyE19o/eTHzFFtmU7FUxagnww2J+L5eHhEuSU LfG/EmIWDZSWYAe7trwMw95/rB2D71Yv7RBx+zc7bzaxmPJG3qukEZxMhbUYQlErXNQa z2c7jRC8fLkIrN/ITZScdqVfG7+t/8ZVdXY3dYRl/kqhtS9NfmRdUPQ1s/jm/IqNXGnu eIAoty6CD1tvjGgbiubRTBdMEdDUaUVmajiZpygOYFY6pPzr2GhfNzK2pHNu+jES2rRI 7Bzw== 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=NmQ9BoJ8yLyYIhlQ2tSE226giVBiae5NVSjB4sM5emU=; fh=H/2unUmiOTl3InSXJn/MJBquReyhFlY0V4qiO1Dyzko=; b=WM59+rtBHu7EYYMnES+rrsOPqbonpsycnZL5hpmOD5Jwp9It/uGJzjiNLc+UMUrQaG n3aeD3U979hEK/FfmtQ3fww7wBruqp3TR283jPUF7p/qYGfzvsUSl+ib/9DOwV1Ddnrl f5c9uUJsRu0zcwsH1ClTp4T1c591zwXiIITzFbx3PdQQPNdC0O0IIYcrSVz3+akIueEo 7buarkF75w9Nmaj9WynrksSoQ9BYCAzubORBQhtOhus87zAZnW756C1fN6ijtBp9Xran 1wLOyIzSz8Ve0/+FynvhfMFwzi/CeYe60QeNFiVsYhtkrcFbng/13wfxeR72oedrCbSO xasw==; darn=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=1774261331; x=1774866131; darn=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=NmQ9BoJ8yLyYIhlQ2tSE226giVBiae5NVSjB4sM5emU=; b=hZiymqSF+e4JuZGUoQwtlgg8+KLTWcvLKUWVsDFQh6xGlrLg46fXFJNspGcY5skOsG wIACeiETIKMV+W0sNSe/ksP+V118ZLKCZGA74gojrCmY9S0/8c75bNudjmTblT+cRXPV JFdVfFucbWtfP0tyzUsCm7JhrdffiTmWtbqBi6vPWkAAz6ethuxSSOmpj6zuz0b7wBm2 hYSrWSy/Gbs1wzcia7xQ/uVAXNMBdQVrBy1+SG9/mllImbrElpBdpRpWotSROIapnqwD XKzynqxzExSu2hjrze7AxWGU9uSkxnVkkZrEHNUlWJ70xOPk8+iVuX/kaf8GDcpocux/ XEQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774261331; x=1774866131; 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=NmQ9BoJ8yLyYIhlQ2tSE226giVBiae5NVSjB4sM5emU=; b=FDWye9zMrdBpPdUU/9ssYIRJYQ/iKDSW9qgJYw0DdsIfy5ieU5c25DwPCmvw/IBAJf k/pbipDJ9PykJXkEhbNz/UNhMLnJO2SCsfJmW1mW/ht/xkK7o4jgY7q98r4NBCabv25V bkzcj4JMAxz6FtxLcbo8Ox1KPhEDHp81qJnA5i0qHTebuYqSkpy3nNOViwbFsUINlnDN HQTEDdI4AaZYb9ni116rrrJYm1yLyvEbl4K+bu8ed45tuT8I/B4JpTkXrsV6TfXUXN8a rKYnRiZXHNhKlZl8UmuFQk8rD1nUUSX16vMybGu7Vv9D1rRApL1p10zcg5Kgbj5WI2AW NnDw== X-Forwarded-Encrypted: i=1; AJvYcCVHfeCfEsAnxX9rvvMxZO2UoYVGdgF6WdY0oE2jeNJpM2qmzfwzfAXaTQQgfhpxDTo5fgfDLXtBYZC9cFGv@postgresql.org X-Gm-Message-State: AOJu0YyjLyxwLDsK4smgZkHCeNmKidLXrVwuJLr5grYxWDfWrhR4L84L bUbf/W4IQn6/f1lZFkl0sbYC48N1rxi5s6RDfvGZ0MT1nLiq2E9gYdkXGFABDyzipQD+P4A0hZt bW1uPnhteo0Ndvld2imLvXTiEn43eMx8= X-Gm-Gg: ATEYQzz/8GVLreeSw/q/p9i9ZsFZaZuWTluJykhxHWJLOlw5/zrhvnTBLP+oBjFXHM+ tjU82tu3t/8fguDOzIBImFHHBH2qQ13NS+vdpB2JOnBYBT+cCgJemrgYmKIsOXZdNMIymNNfXg6 n2OT41fwaS5sELNHXMnFpkcPwmGGCUdWK/VX2dA/sb7fXgoE51eXCo6k20Gbp93Ci868RJLbUuQ tXvR+HPnHv2zYRwIArOuF5IPELgS186WC9lswSn/XlDZhpl92b4yRKmaQQ1GXQ6VCto+YyoPzdR d+HmKeg= X-Received: by 2002:a05:7023:b82:b0:128:d714:3ca2 with SMTP id a92af1059eb24-12a7264e095mr5392014c88.2.1774261331202; Mon, 23 Mar 2026 03:22:11 -0700 (PDT) MIME-Version: 1.0 References: <2f3fa419-9000-4e2a-b070-6e35d5de0e4c@uni-muenster.de> <751a6cb8-cac8-46c4-8c64-9e23f663e926@uni-muenster.de> In-Reply-To: From: Soumya S Murali Date: Mon, 23 Mar 2026 15:52:36 +0530 X-Gm-Features: AaiRm51Z16-Pdg537_q81AkjcTL-sEs2cmiVgs1XZqSWl8YhrM76oPWVgDrxJZ4 Message-ID: Subject: Re: Fix bug with accessing to temporary tables of other sessions To: Daniil Davydov <3danissimo@gmail.com> Cc: Jim Jones , Stepan Neretin , PostgreSQL Hackers 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 Hi all, Thank you for the updated patches. On Mon, Mar 23, 2026 at 12:56=E2=80=AFPM Daniil Davydov <3danissimo@gmail.c= om> wrote: > > Hi, > > Posting rebased set of patches. I have gone through the patches and tested the patch series. I successfully reproduced the bug before applying the patch and found that the cross-session SELECT via schema-qualified temp table did not raise an error; instead, it returned an empty result, indicating inconsistent behaviour. After applying the patch, regression tests passed successfully and new regression tests behave as expected. Temporary tables from other sessions are now no longer visible and all the attempts to access them result in error. Also I verified:- Schema-qualified SELECT, INSERT / UPDATE / DELETE, JOIN queries, Subqueries and EXPLAIN worked as expected. Same-session access also works as expected. Overall the patch LGTM. Regards, Soumya