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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]
Дата
Msg-id 48071981-2978-31ac-f960-531420e24b7a@aklaver.com
обсуждение исходный текст
Ответ на Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]  (Ron <ronljohnsonjr@gmail.com>)
Список 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.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Is it possible to use keywords (date units) in a functiondefinition?