flowchart LR
B["BEGIN\nbuffer statements"] --> W["writes\nWAL Data + memory buffer"]
W --> C["COMMIT\none storage txn: batch + fsync + publish"]
W --> R["ROLLBACK\nAbort + discard"]
C --> V["visible per\nMVCC snapshot rules"]Diagram source · mermaidcopy included
flowchart LR
B["BEGIN\nbuffer statements"] --> W["writes\nWAL Data + memory buffer"]
W --> C["COMMIT\none storage txn: batch + fsync + publish"]
W --> R["ROLLBACK\nAbort + discard"]
C --> V["visible per\nMVCC snapshot rules"]See Run transactions for the task guide. This page is the precise reference.
BEGIN [TRANSACTION|WORK] [ISOLATION LEVEL …|READ ONLY|…]
START TRANSACTION […] | SET [SESSION|LOCAL] TRANSACTION … | SET … CHARACTERISTICS …
COMMIT [opts] | ROLLBACK [TO [SAVEPOINT] name] [opts]execute_allsplits batches depth-aware on;;BEGINbuffers intopending;COMMIT|ROLLBACKruns the group as one storage transaction.- In-txn writes allowed:
INSERT/UPDATE/DELETE+CREATE TABLE|VIEW.COPYandUPDATE…FROMin-txn →Unsupported. SET search_pathin-batch affects later statements.SET TRANSACTION ISOLATION LEVEL {READ COMMITTED | REPEATABLE READ}andSET SESSION CHARACTERISTICSare accepted and stored as the session default;SERIALIZABLEis rejected, as is changing it mid-transaction or issuingSET TRANSACTIONoutside a transaction block.- Idle transactions are reaped after
idle_in_transaction_session_timeout(default 60s,0disables): the connection closes with25P03— commit or roll back promptly. See Pooling and errors.
Isolation options parse but the engine is single-writer with MVCC snapshots (see MVCC); there is no multi-writer serializable scheduler to tune in v0.1.0.
Was this page helpful? Thanks — noted locally, nothing is sent anywhere.