Re: Fix bug with accessing to temporary tables of other sessions - Mailing list pgsql-hackers

Hi,

On Mon, Apr 13, 2026 at 7:39 PM 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 access
other session's temp table only by its name. It will not work since postgres
will search this name within the "pg_temp" schema of the current session. You
should explicitly specify other session's temp schema name in order to access
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