Mercurial > hg > orthanc-databases
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; |