MIME-Version: 1.0
References: 
 <CAJDiXghdFcZ8=nh4G69te7iRr3Q0uFyXxb3ZdG09_GTNZXwH0g@mail.gmail.com>
 <CAJDiXgj5rFYxuLYSpQxidQ+1cZ=6rJx29MvV+RAjKX7B=EGUvw@mail.gmail.com>
 <CAJDiXggOEN06RwBBCJ-egzkmTbm81=LJ5eCNmvzr=Bpwnp5VzA@mail.gmail.com>
 <CAJDiXgi7tWm_y0i7kD8fMxGe=86_W-hMxyQS+g7-7cdTzd-KRQ@mail.gmail.com>
 <CAMtXxw_ta_9i=uPJMvGueOBc04crmraJXcyJhN0K=Wu9aa2rog@mail.gmail.com>
 <1a32fc83-df78-4774-97dc-2bb06dbb16e9@uni-muenster.de>
 <3529398.1774273446@sss.pgh.pa.us>
 <CAJDiXgh9g4TEyF3kWCiBgHX6QbpATZtxTfrQuBCKxUO5=nZBOw@mail.gmail.com>
 <4075754.1774378690@sss.pgh.pa.us>
 <CAJDiXgihovkP6DMAFyJtYF4JSAjvKmiRVbF5R5n3SA=Yag32_w@mail.gmail.com>
 <CAMtXxw8pHLH9+mG3wxsF8f=Y+pHqTNP8X1UmZQPkRL9pZ5aF2w@mail.gmail.com>
 <67637cf8-8cbf-4f86-8775-52aa0329972d@uni-muenster.de>
 <b13dc5ba-6c11-429c-b6fe-673c1c767bcf@uni-muenster.de>
 <CAJDiXgiAObr4c+PTWSS19vcohrFSDLK3MC5FK3TekMB3U3DjfQ@mail.gmail.com>
 <e58a9580-7bbf-4d70-ad99-833fab77cf88@uni-muenster.de>
 <CAJDiXghBO_TqvHOSui8MOxiFmwLT20+SAnH5nW1rpWHk7Jwffg@mail.gmail.com>
 <402bbc8d-728b-4467-8024-31c2bc101ead@uni-muenster.de>
 <CAJDiXgi0JFk0f2KWWQkzLBC5P7erX9WP18qqnbi-rjZ-K-P=3w@mail.gmail.com>
 <CAMtXxw_hBNuAWQUdSRMpoeRVRYr+5+S7p0bSzuqtHxfpzJPd3w@mail.gmail.com>
In-Reply-To: 
 <CAMtXxw_hBNuAWQUdSRMpoeRVRYr+5+S7p0bSzuqtHxfpzJPd3w@mail.gmail.com>
From: Daniil Davydov <3danissimo@gmail.com>
Date: Mon, 13 Apr 2026 21:18:07 +0700
Message-ID: 
 <CAJDiXgi13j8KoK_19Wy_pW=hB_-KmtFUnkzUG++NFxkxXDxkEg@mail.gmail.com>
Subject: Re: Fix bug with accessing to temporary tables of other sessions
To: Soumya S Murali <soumyamurali.work@gmail.com>
Cc: Jim Jones <jim.jones@uni-muenster.de>, Tom Lane <tgl@sss.pgh.pa.us>,
	Stepan Neretin <slpmcf@gmail.com>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAJDiXgi13j8KoK_19Wy_pW%3DhB_-KmtFUnkzUG%2B%2BNFxkxXDxkEg%40mail.gmail.com>
Precedence: bulk

Hi,

On Mon, Apr 13, 2026 at 7:39=E2=80=AFPM Soumya S Murali
<soumyamurali.work@gmail.com> wrote:
>
>
> I tested the v16 patch on a clean tree and verified the behavior
> across multiple execution paths.

Thanks!

> Cross-session access is consistently
> blocked; all attempts result in an error - "relation does not exist"

Hm, our patch should give an error like "cannot access temporary relations =
of
other sessions". If you see "relation does not exist" I guess you try to ac=
cess
other session's temp table only by its name. It will not work since postgre=
s
will search this name within the "pg_temp" schema of the current session. Y=
ou
should explicitly specify other session's temp schema name in order to acce=
ss
its temp tables. You can find examples in our new test.

Please, let me know if I am wrong and the current patch actually allows
"relation does not exist" error to occur. In this case, it should be fixed.

--
Best regards,
Daniil Davydov