I am experimenting with EXCLUSIVE transactions today, and was confused
that after one connection began an EXCLUSIVE transaction, another one
could still execute a SELECT statement, because quoting from
"After a BEGIN EXCLUSIVE, no other database connection except for
read_uncommitted connections will be able to read the database and no
other connection without exception will be able to write the database
until the transaction is complete."
I do understand the concept of the different lock types and that a
SELECT statement does not implicitly start a transaction, but the quoted
paragraph does not make this clear in my mind, or am I reading it wrong?
Hearing your opinions on this is highly appreciated.