Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]
Date: 2020-06-08 22:31:26
Message-ID: c3ae5120-fa33-1bb5-dbc7-d4804e84c712@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. :)

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-06-08 22:38:06 Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]
Previous Message David G. Johnston 2020-06-08 22:10:42 Re: Is it possible to use keywords (date units) in a function definition?