Re: CREATE DATABASE command concurrency

2024-09-18 Thread Muhammad Usman Khan
Hi, In PostgreSQL, it's safe to run CREATE DATABASE at the same time from different places. If two commands try to create the same database, one will succeed, and the other will safely fail without causing any problems or incomplete database creation. On Wed, 18 Sept 2024 at 19:08, Wizard Brony w

Re: CREATE DATABASE command concurrency

2024-09-18 Thread Tom Lane
Christophe Pettus writes: >> On Sep 17, 2024, at 14:52, Wizard Brony wrote: >> What are the concurrency guarantees of the CREATE DATABASE command? For >> example, is the CREATE DATABASE command safe to be called concurrently such >> that one command succeeds and the other reliably fails without

Re: CREATE DATABASE command concurrency

2024-09-18 Thread Christophe Pettus
> On Sep 17, 2024, at 14:52, Wizard Brony wrote: > > What are the concurrency guarantees of the CREATE DATABASE command? For > example, is the CREATE DATABASE command safe to be called concurrently such > that one command succeeds and the other reliably fails without corruption? The concern

CREATE DATABASE command concurrency

2024-09-18 Thread Wizard Brony
What are the concurrency guarantees of the CREATE DATABASE command? For example, is the CREATE DATABASE command safe to be called concurrently such that one command succeeds and the other reliably fails without corruption?