Re: Global temporary tables - Mailing list pgsql-hackers

From Philippe BEAUDOIN
Subject Re: Global temporary tables
Date
Msg-id 157703426606.1198.2452090605041230054.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: Global temporary tables  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: Global temporary tables
List pgsql-hackers
Hi all,

I am not aware enough in the Postgres internals to give advice about the implementation.

But my feeling is that there is another big interest for this feature: simplify the Oracle to PostgreSQL migration of
applicationsthat use global termporary tables. And this is quite common when stored procedures are used. In such a
case,we currently need to modify the logic of the code, always implementing an ugly solution (either add CREATE TEMP
TABLEstatements in the code everywhere it is needed, or use a regular table with additional TRUNCATE statements if we
canensure that only a single connection uses the table at a time).
 

So, Konstantin and all, Thanks by advance for all that could be done on this feature :-)

Best regards.

pgsql-hackers by date:

Previous
From: Maxence Ahlouche
Date:
Subject: Re: Invisible PROMPT2
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: schema variables