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)
Im contemplating using the DBI interface as a permanent client to postgres for a group of users, and have a few