Postgres Pro
Downloads
Home   >   mailing lists

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

From Thorsten Schöning
Subject Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]
Date
Msg-id 1561641372.20200608112737@am-soft.de
Whole thread Raw
In response to Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]  ("Daniel Verite" <daniel@manitou-mail.org>)
Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]  (Ravi Krishna <srkrishna@outlook.com>)
List pgsql-general
Tree view 
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.Schoening@AM-SoFT.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

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]
Next
From: "Daniel Verite"
Date:
Subject: Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]