Re: CREATE DATABASE command concurrency

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: CREATE DATABASE command concurrency
Дата
Msg-id D36748A9-A7FA-48DF-B8D0-A14E5DE545EF@thebuild.com
обсуждение исходный текст
Ответ на CREATE DATABASE command concurrency  (Wizard Brony <wizardbrony@gmail.com>)
Ответы Re: CREATE DATABASE command concurrency
Список pgsql-general

> On Sep 17, 2024, at 14:52, Wizard Brony <wizardbrony@gmail.com> wrote:
>
> What are the concurrency guarantees of the CREATE DATABASE command? For example, is the CREATE DATABASE command safe
tobe called concurrently such that one command succeeds and the other reliably fails without corruption? 

The concern is that two different sessions issue a CREATE DATABASE command using the same name?  In that case, it can
berelied upon that one will succeed (unless it fails for some other reason, like lacking permissions), and the other
willreceive an error that the database already exists. 


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