Can I read a locked string [in Postgres]?

If I SELECT... FOR UPDATE row in a transaction, it obviously blocks the row from writing, but will it also block reading? I would prefer that everything can still be read from a line, so if so, can you provide a solution for this?

+6
source share
1 answer

You can read very well. There are lock modes that prevent reading, but this is not one of them.

http://www.postgresql.org/docs/current/static/explicit-locking.html

+7
source

Source: https://habr.com/ru/post/923242/


All Articles