Re: CREATE DATABASE command concurrency - Mailing list pgsql-general

From Christophe Pettus
Subject Re: CREATE DATABASE command concurrency
Date
Msg-id D36748A9-A7FA-48DF-B8D0-A14E5DE545EF@thebuild.com
Whole thread Raw
In response to CREATE DATABASE command concurrency  (Wizard Brony <wizardbrony@gmail.com>)
Responses Re: CREATE DATABASE command concurrency
List 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 by date:

Previous
From: Andy Hartman
Date:
Subject: Re: load fom csv
Next
From: Adrian Klaver
Date:
Subject: Re: load fom csv