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

From: Thorsten Schöning <tschoening(at)am-soft(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]
Date: 2020-06-08 09:27:37
Message-ID: 1561641372.20200608112737@am-soft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Guten Tag Daniel Verite,
am Montag, 8. Juni 2020 um 11:05 schrieben Sie:

> The caveat you mention about IF NOT EXISTS does not apply to
> temporary tables, as they're not shared across sessions.[...]

That's what I understood as well, but I'm creating those concurrently
WITHIN one and the same session and transaction. :-) And that's where
I wanted to make sure that I properly understood things using my
questions.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail: Thorsten(dot)Schoening(at)AM-SoFT(dot)de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michaeldba@sqlexec.com 2020-06-08 09:50:35 Re: When to use PARTITION BY HASH?
Previous Message Daniel Verite 2020-06-08 09:05:02 Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]