gmcabrita
Joined 15 years ago
Karma
1,551
Submissions
92
Member since
Oct 23
Recent submissions
Comment · 9 months ago
Your comment is 100% not true: https://dbfiddle.uk/Iu-u886S
Comment · 1 year ago
> PostgreSQL takes FOR UPDATE on rows before a DELETE, or before an UPDATE that modifies a column that is part of a unique index that neither contains expressions nor is partial
This also happens when you UPDATE the same row twice within the same transaction.