On Tue, Oct 10, 2023 at 3:43 PM Alexander Korotkov <aekorotkov@gmail.com> wrote:
> Yep, in v43 it worked that way. One transaction has to wait for
> another finishing update of pg_database tuple, then fails. This is
> obviously ridiculous. Since overlapping setters of flag will have to
> wait anyway, I changed lock mode in v44 for them to
> AccessExclusiveLock. Now, waiting transaction then sees the updated
> tuple and doesn't fail.
Doesn't that mean that if you create the first login trigger in a
database and leave the transaction open, nobody can connect to that
database until the transaction ends?
--
Robert Haas
EDB: http://www.enterprisedb.com