From dd7567fd05b29004c6517963923deacadfbc0a73 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Sun, 27 Aug 2023 14:05:09 +0200 Subject: -fix issue with multiple dbinit running concurrently --- src/stasis/versioning.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/src/stasis/versioning.sql b/src/stasis/versioning.sql index 116f409..c7fa812 100644 --- a/src/stasis/versioning.sql +++ b/src/stasis/versioning.sql @@ -146,12 +146,17 @@ BEGIN; +-- Added by Christian Grothoff to support concurrency, see +-- https://stackoverflow.com/questions/29900845/create-schema-if-not-exists-raises-duplicate-key-error?rq=4 +LOCK TABLE pg_catalog.pg_namespace; + + -- This file adds versioning support to database it will be loaded to. -- It requires that PL/pgSQL is already loaded - will raise exception otherwise. -- All versioning "stuff" (tables, functions) is in "_v" schema. -- All functions are defined as 'RETURNS SETOF INT4' to be able to make them to RETURN literally nothing (0 rows). --- >> RETURNS VOID<< IS similar, but it still outputs "empty line" in psql when calling. +-- >> RETURNS VOID<< IS similar, but it still outputs "empty line" in psql when calling CREATE SCHEMA IF NOT EXISTS _v; COMMENT ON SCHEMA _v IS 'Schema for versioning data and functionality.'; -- cgit v1.2.3