| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...] |
| Date: | 2020-06-08 22:38:06 |
| Message-ID: | 48071981-2978-31ac-f960-531420e24b7a@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-06-08 22:40:05 | Re: Is it possible to use keywords (date units) in a function definition? |
| Previous Message | Ron | 2020-06-08 22:31:26 | Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...] |