db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

virtualxid and transactionid

Every transaction holds a virtualxid lock. Only writers get a transactionid lock, and only once they write.

task

In one statement insert a row (WITH ... INSERT ... RETURNING) and list the distinct locktypes of this backend among virtualxid and transactionid, ordered.

hints