Re: Fix bug with accessing to temporary tables of other sessions

From: Daniil Davydov <3danissimo(at)gmail(dot)com>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, Soumya S Murali <soumyamurali(dot)work(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stepan Neretin <slpmcf(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Mohamed Ali <moali(dot)pg(at)gmail(dot)com>, Nazneen Jafri <jafrinazneen(at)gmail(dot)com>, Shawn McCoy <shawn(dot)the(dot)mccoy(at)gmail(dot)com>
Subject: Re: Fix bug with accessing to temporary tables of other sessions
Date: 2026-06-30 12:01:20
Message-ID: CAJDiXggCNfp1sJ-WeFRmdbR14CGJ0Ep5OxiociWkFM+FZ_Y5NQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Tue, Jun 30, 2026 at 6:46 PM Alexander Korotkov <aekorotkov(at)gmail(dot)com> wrote:
>
> > BTW, we still have another problem with temp tables. Tom wrote [1] about it
> > within this thread:
> >
> > > Reality is that we cannot know whether an
> > > unqualified-name RangeVar references a temp table until we do a
> > > catalog lookup, so IMO we should not have a relpersistence field there
> > > at all. At best it means something quite different from what it means
> > > elsewhere, and that's a recipe for confusion. But changing that would
> > > not be a bug fix (AFAIK) but refactoring to reduce the probability of
> > > future bugs.
> >
> > I'll try to implement that next month. But if someone gets ahead of me, please
> > attach me in CC of the new thread.
>
> Just a friendly ping on how is it going.

Sorry, I was too busy with my studies and completely forgot about it...
I will start working on the patch within this week. Thanks for reminding me.

BTW, recently I found out that we haven't completely gotten rid of the problem
discussed here, so I started a new thread [1]. I think it might interest you.

[1] https://www.postgresql.org/message-id/flat/CAJDiXgiX2XZBHDNo%2BzBbvku%2BtchrUurvPRaN1_40mEQ1_sG90g%40mail.gmail.com

--
Best regards,
Daniil Davydov

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ranier Vilela 2026-06-30 12:23:20 Refactor function pg_get_multixact_stats (src/backend/utils/adt/multixactfuncs.c)
Previous Message Dilip Kumar 2026-06-30 11:50:10 Re: Proposal: Conflict log history table for Logical Replication