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

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]
Дата
Msg-id SN6PR01MB4175726AAE33C459F63A9442B9850@SN6PR01MB4175.prod.exchangelabs.com
обсуждение исходный текст
Ответ на Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS [...]  (Thorsten Schöning <tschoening@am-soft.de>)
Список pgsql-general

> That's what I understood as well, but I'm creating those concurrently
> WITHIN one and the same session and transaction. :-) 

Did I interpret this as "two different sessions via application threads within the same transactions of PG".
Does the thread create its own PG session for each thread or share it across threads.

I would be wary of running concurrent threads within the same transactions. RDBMSs are not designed
to allow multiple SQLstatements running concurrently within the same session, if at all possible.

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

Предыдущее
От: Paul Förster
Дата:
Сообщение: Re: Postgres 12 RLS
Следующее
От: Laura Smith
Дата:
Сообщение: Re: Postgres 12 RLS