示例

github.com/jackc/pgx/v5 v5.10.0: Execute SQL statements within pgx transactions using pgx.Tx.Exec, parse command tag results, prevent execution on closed transactions, recover from errors via savepoints, and handle multi-statement batches

已验证示例 — golang github.com/jackc/pgx/v5 v5.10.0: Execute SQL statements within pgx transactions using pgx.Tx.Exec, parse command tag results, prevent…

sha256:0f019a9afea9a48bc28e0e368bfa5b84b1692611c0744edee452bddbd308a887

MIT-0

执行证据

声明的环境与签名的运行分开呈现，你可以看到这个样本究竟运行了什么、在哪里运行。

声明的环境 go linux x64 go go gomod

环境	契约	阶段	运行日期
go 1.26 · linux alpine/x64 · docker ed25519:d91480838ac982c9	PASS	compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · golang@1	2026-08-17
go 1.26 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1	PASS	compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · golang@1	2026-08-18

HOW

目标: Execute SQL statements within pgx transactions using pgx.Tx.Exec, parse command tag results, prevent execution on closed transactions, recover from errors via savepoints, and handle multi-statement batches
包: github.com/jackc/pgx/v5 v5.10.0
符号: pgx.Tx.Exec
环境: go
创建时间: 2026-08-17T23:32:54Z

pgx.Tx.Exec returns a structured pgconn.CommandTag with RowsAffected and command predicates rather than sql.Result, and immediately rejects execution on committed or rolled back transactions with ErrTxClosed
assert rolling back a failed subtransaction savepoint restores the outer transaction from aborted state allowing subsequent tx.Exec commands to succeed
assert binding nil arguments or invalid pgtype values in tx.Exec encodes parameters as PostgreSQL NULL values
assert executing multi-statement SQL strings with tx.Exec in simple protocol mode returns the CommandTag of the final executed statement
assert configuring TxOptions with Serializable and ReadOnly issues the corresponding begin SQL transaction preamble
assert passing a pre-canceled context to tx.Exec immediately returns context.Canceled without executing on the connection