Is there a way to indicate shared intended exclusive locks on page/row level (update locks) like locking hints or Select For Update ? I am not on MVCC and I'd would use it to avoid deadlocks in certain situations

If you're not using MVCC then pessimistic locking is all you have to
work with. In which case all you can do is SET LOCKMODE SESSION WHERE
READLOCK=EXCLUSIVE.

That'll be highly disruptive if you don't immediately revert to
READLOCK=SYSTEM as soon as you no longer need it.


--
rhann

It has to be issued outside the scope of a transaction (i.e. following a
commit or a rollback) so for practical purposes it takes effect on the
first query after you set it.


--
rhann