4 ms·
This seems quite false. NOWAIT would error in the face of locked rows. SKIP LOCKED skips without error. "With NOWAIT, the statement reports an error, rather t
by shawn-butler 9y ago
This seems quite false. NOWAIT would error in the face of locked rows. SKIP LOCKED skips without error.
"With NOWAIT, the statement reports an error, rather than waiting, if a selected row cannot be locked immediately. Note that NOWAIT applies only to the row-level lock(s) — the required ROW SHARE table-level lock is still taken in the ordinary way"