v0.6.0b12

What's Changed

• site: v0.6.0b11 release blog post by @jdrumgoole in #888
• ci(security): explicit least-privilege permissions on validate.yml jobs by @jdrumgoole in #890
• fix(sql): reply-shape fidelity — verbatim ?column?, array-cast names, int4 series by @jdrumgoole in #891
• docs: pgx gauge refreshed — 96.3% (364/14/22) at 303c793, from 77.0% by @jdrumgoole in #894
• fix(security): admin UI stored XSS via collection name in Alpine directive by @jdrumgoole in #893
• fix(sql): txn-scoped SET unwinding + ParameterStatus re-reports; SAVEPOINT passes the parse guard by @jdrumgoole in #889
• fix(security): aggregate secondary-namespace RBAC + configureFailPoint gating by @jdrumgoole in #892
• fix(security): SQL write statements require read grants on their source tables by @jdrumgoole in #895
• fix(security): bound async-oplog pre-image buffer + poison-tolerant oplog locks by @jdrumgoole in #897
• fix(security): gate large-object writes with RBAC + read-only-transaction checks by @jdrumgoole in #896
• fix(security): coll-lock drop_index + exception-safe bare oplog emit by @jdrumgoole in #898
• fix(security): LISTEN idle-poll must not truncate a wire frame mid-read by @jdrumgoole in #899
• docs: pgjdbc gauge re-baseline — 98.6% (5493P/77F) by @jdrumgoole in #900
• feat(sql): BEFORE INSERT row triggers with plpgsql NEW records by @jdrumgoole in #901
• chore(security): bump PyO3 0.22 → 0.29, clearing two RUSTSEC advisories by @jdrumgoole in #902
• docs: pgx gauge closed — 99.5% (376/2/22) at 03d5c63; pgconn 0 stable by @jdrumgoole in #903
• feat(sql): record SRFs in the SELECT list + search_path-aware pg_table_is_visible by @jdrumgoole in #904
• docs(backlog): _pg_expandarray cluster resolved (#904) by @jdrumgoole in #905
• fix(sql): temp-namespacing fallout — bare diag names, self-ref FKs by @jdrumgoole in #906
• feat(sql): PG error-identity fields on constraint violations + equality EXCLUDE by @jdrumgoole in #907
• [security-critical] Security Review — 2026-08-16 by @github-actions[bot] in #908
• fix(sql): aborted-txn pipeline semantics — 25P02 + ignore_till_sync by @jdrumgoole in #911
• fix(sql): malformed parameters raise proper SQLSTATEs, never XX000 by @jdrumgoole in #913
• fix(sql): multidim arrays keep base type; JSON[] keeps oid 199 by @jdrumgoole in #914
• feat(sql): side-effect-free Describe, regclass/regtype, DateStyle input, geo binary results by @jdrumgoole in #912
• docs: pgjdbc gauge re-baseline — 99.0% (5512P/58F) by @jdrumgoole in #915
• feat(sql): verbatim plain-json echo; jsonb binary validation; 42804 by @jdrumgoole in #916
• test: fix the xdist worker-death root cause — bounded flock waits + sigtrace by @jdrumgoole in #917
• feat(sql): multi-statement batches run in one implicit transaction by @jdrumgoole in #919
• feat(sql): COMMENT ON FUNCTION + table row types as column types by @jdrumgoole in #918
• feat(sql): regclass parameter oids + bind-time portal snapshots by @jdrumgoole in #921
• feat(sql): the internal one-byte "char" type (oid 18) — pgtest char corpus by @jdrumgoole in #922
• fix(sql): ResultSetMetaData fidelity — STRUCT oids, base columns, declared typmods by @jdrumgoole in #920
• feat(sql): citext rides oid 90008 — pgtest citext corpus green by @jdrumgoole in #923
• feat(sql): unblock DatabaseMetaDataTest setup — pg_description DML, operator DDL, PK USING INDEX, composite arrays by @jdrumgoole in #924
• feat(sql): byte-exact COPY CSV fidelity + extended-protocol COPY TO by @jdrumgoole in #925
• feat(sql): plpgsql refcursors — OPEN … FOR, CLOSE, FETCH by portal name by @jdrumgoole in #926
• docs(sql): precision ceilings (ms timestamps, 34-digit numeric); BatchDeadlockTest closed out by @jdrumgoole in #928
• feat(sql): COPY option keyword allowlist + custom CSV QUOTE by @jdrumgoole in #927
• fix(sql): binary numeric zero rendering + dscale validation — pgtest decimal green by @jdrumgoole in #929
• fix(sql): four DatabaseMetaData catalog gaps — max_index_keys, proargmodes, reltuples, output-alias ORDER BY by @jdrumgoole in #930
• feat(sql): enum casts describe like PG — pgtest enum corpus green by @jdrumgoole in #931
• feat(sql): atomic multi-name DROP TABLE + Bind format-code validation by @jdrumgoole in #932
• fix(sql): EXECUTE portals describe their underlying statement by @jdrumgoole in #933
• fix(sql): FK metadata conindid + $unwind fast path; worker-death pytestmark overwrite by @jdrumgoole in #934
• feat(sql): single-precision float fidelity — pgtest float corpus green by @jdrumgoole in #935
• feat(sql): nested BEGIN warns 25001 like PG — pgtest implicit_txn green by @jdrumgoole in #936
• feat(sql): COMMENT ON DOMAIN/INDEX + obj_description; PITR tests on one worker by @jdrumgoole in #937
• fix(sql): binary inet error classes — pgtest inet corpus green by @jdrumgoole in #938
• feat(sql): binary int2vector encodes as an int2 array by @jdrumgoole in #939
• fix(sql): keywordless ALTER TABLE … DROP by @jdrumgoole in #940
• feat(sql): the jsonpath type — pgtest jsonpath to documented divergence by @jdrumgoole in #941
• feat(sql): the ltree type — pgtest ltree corpus green by @jdrumgoole in #942
• feat(sql): pg_get_keywords(), aggregates over SRF sources, <> ALL(array) by @jdrumgoole in #943
• feat(sql): PostgreSQL portal semantics (42P03 / lifetime / 55006) by @jdrumgoole in #944
• [security-critical] Security Review — 2026-08-17 by @github-actions[bot] in #945
• fix(sql): getCatalogs lists the postgres maintenance database by @jdrumgoole in #950
• docs(backlog): record domainColumnSize design by @jdrumgoole in #951
• fix(sql): reg* pseudo-types use the oid wire form — pgtest oid corpus green by @jdrumgoole in #952
• test: tolerate a nested-run wedge that beats the summary line by @jdrumgoole in #953
• feat(sql): GUC reporting matches PG — pgtest param_status corpus green by @jdrumgoole in #954
• feat(sql): parameter typing follows PG's parse analysis by @jdrumgoole in #955
• fix(sql): portal Execute suspension and per-Execute row counts by @jdrumgoole in #956
• fix(sql): Bind validates its parameter count — pgtest prepare corpus green by @jdrumgoole in #957
• test(pgtest): one daemon per corpus file — the gauge count was inflated by @jdrumgoole in #958
• docs: promote the 0.6.0b12 changelog entry and document the new SQL types by @jdrumgoole in #959

Full Changelog: v0.6.0b11...v0.6.0b12