When a SELECT FOR UPDATE query is executed, are the row level locks on a
table acquired in any specific order such as to enhance deadlock
prevention? ( primary key, oid, etc. )
---(end of broadcast)---
TIP 8: explain analyze is your friend
Title: "select for update" question
Hello,
As I understand it:
Issuing a “select for update” within a transaction will prevent other users from modifying data. (exclusive lock)
I’m contemplating using the DBI interface as a permanent client to postgres for a group of users, and have a few
