Transaction behavior

Pivot commits each statement individually. BEGIN, COMMIT, and ROLLBACK are accepted for driver compatibility, but they do not group statements into a transaction.

ROLLBACK does not undo writes

Writes issued between BEGIN and ROLLBACK are already committed and remain in place. Do not rely on these commands for multi-statement atomicity.

Accepted syntax

BEGIN;
COMMIT;
ROLLBACK;

Driver compatibility

Some PostgreSQL drivers wrap statements in a transaction automatically. Pivot answers these commands with their usual response tags so those clients can connect and issue statements. The responses do not imply that a transaction was opened, committed as a group, or rolled back.

Related

• INSERT
• COPY
• SQL reference