comparison PostgreSQL/Plugins/PostgreSQLDefinitions.h @ 418:a7f0f27fe33c pg-transactions

wip: advisory lock around CreateInstance: not ok see WO-139
author Alain Mazy <am@osimis.io>
date Tue, 27 Jun 2023 15:17:39 +0200
parents 3d6886f3e5b3
children f0976163dbe1
comparison
equal deleted inserted replaced
417:15bfd9a76f8d 418:a7f0f27fe33c
46 * because concurrent statements like "CREATE TABLE" are not protected 46 * because concurrent statements like "CREATE TABLE" are not protected
47 * by transactions. 47 * by transactions.
48 * https://groups.google.com/d/msg/orthanc-users/yV3LSTh_TjI/h3PRApJFBAAJ 48 * https://groups.google.com/d/msg/orthanc-users/yV3LSTh_TjI/h3PRApJFBAAJ
49 **/ 49 **/
50 static const int32_t POSTGRESQL_LOCK_DATABASE_SETUP = 44; 50 static const int32_t POSTGRESQL_LOCK_DATABASE_SETUP = 44;
51
52 /**
53 * Transient advisory lock to protect the instance creation,
54 * because it is not 100% resilient to concurrency in, e.g, READ COMIITED
55 * transaction isolation level.
56 **/
57 static const int32_t POSTGRESQL_LOCK_CREATE_INSTANCE = 45;