Is it expected that select for update doesn't work with left outer joins? Just curious. I only need to lock one of the tables so far, so it's not a problem. Link.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных