Can SELECT … NOWAIT “deadlock”?

2019-08-20 Thread Toni Cárdenas
The docs say (emphasis mine): > FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE and FOR KEY SHARE are locking clauses; they affect how SELECT locks rows **as they are obtained from the table**. > With NOWAIT, the statement reports an error, rather than waiting, if a selected row cannot be locked immedia

Can SELECT … NOWAIT “deadlock”?

2019-08-20 Thread Toni Cárdenas
The docs say (emphasis mine): > FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE and FOR KEY SHARE are locking clauses; they affect how SELECT locks rows **as they are obtained from the table**. > With NOWAIT, the statement reports an error, rather than waiting, if a selected row cannot be locked immedia