Using ctid to implement optimistic locking fails in PostgreSQL
I compared the method of using PostgreSQL’s hidden column ctid
to implement optimistic locking and the new column version
to implement optimistic locking. I found that using ctid would fail, but I couldn’t figure out the reason.