Postgres Pro
Downloads
Home   >   mailing lists

Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...] - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]
Date
Msg-id 48071981-2978-31ac-f960-531420e24b7a@aklaver.com
Whole thread Raw
In response to Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 
On 6/8/20 3:31 PM, Ron wrote:
> On 6/8/20 9:23 AM, Thorsten Schöning wrote:
>> Guten Tag Ron,
>> am Montag, 8. Juni 2020 um 15:35 schrieben Sie:
>>
>>> Would a set of GLOBAL temporary tables be a better fit for your problem
>>> (eliminating the need to create temporary tables each time)?
>> Do you mean plain tables simply created using CREATE TABLE or is there
>> some additional concept of temporary tables I'm not aware of? Because I
>> thought truly temporary tables are always session-specific:
> 
> Hmm...  Postgres doesn't support global temporary tables.  Never mind. :)
> 

There is a newly released extension that offers that:

https://www.postgresql.org/message-id/4a390375-0a69-8901-fc5a-4a0336c5c6b4%40darold.net

-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]
Next
From: Adrian Klaver
Date:
Subject: Re: Is it possible to use keywords (date units) in a functiondefinition?