public inbox for [email protected]  

help / color / mirror / Atom feed

From: Philippe BEAUDOIN <[email protected]>
To: [email protected]
Cc: Konstantin Knizhnik <[email protected]>
Subject: Re: Global temporary tables
Date: Sun, 22 Dec 2019 17:04:26 +0000
Message-ID: <157703426606.1198.2452090605041230054.pgcf@coridan.postgresql.org> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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 applications that 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 TABLE statements in the code everywhere it is needed, or use a regular table with additional TRUNCATE statements if we can ensure 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.

view thread (492+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Global temporary tables
  In-Reply-To: <157703426606.1198.2452090605041230054.pgcf@coridan.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox