@effect/sql-pg@4.0.0-rc.117

Patch Changes

• #8309 7869f54 Thanks @tristanz! - Decode binary regclass and regclass[] values as unsigned numeric OIDs, fixing the migration runner's table-existence check. Cast regclass values to text in SQL to return relation names.

• #8327 201b5ab Thanks @tim-smart! - Namespace prepared statement names per connection to avoid collisions when backend sessions are shared.

• #8308 106af64 Thanks @tristanz! - Release savepoints after nested transactions succeed or successfully roll back in PostgreSQL, PGlite, MySQL, libSQL, and the Node, Bun, React Native, and WASM SQLite clients. This frees PostgreSQL transaction locks before the outer transaction completes.

  Custom SQL clients can opt in through the new releaseSavepoint option. Clients that omit it are unchanged.

• #8330 27de875 Thanks @tim-smart! - Retire pooled PostgreSQL sessions with an unconfirmed CancelRequest, preventing a delayed cancel from reaching a later checkout. This includes interrupts sent while idle. The current checkout and unpooled sessions remain exposed to their own late cancel.

• Updated dependencies [9953c92, c6e8b20, 8d40572, 1b21e0d, 3b155e3, 895d944, 705fb68, 87912c0, 106af64, 1b21e0d, 3d59ae6, 89c9a39]:

  • effect@4.0.0-rc.117