Welcome to pgrx v0.13.0. The first update in a little bit, which makes pgrx current with upstream dependencies, rust 1.85.0 (but not 2024 Edition, yet), and a slew of fixes and cleanups and community contributions.

Upgrading

You'll need to cargo install cargo-pgrx --version 0.13.0 --locked to get the latest cargo-pgrx tool, and then you can run cargo pgrx upgrade in your extension crates to update their dependencies.

Breaking Changes

Generally, the only breaking changes in v0.13.0 are related to the user-facing SPI APIs. In general, SPI functions that previously took a Vec of Arguments now take a &[DatumWithOid], with proper lifetime bounds. This is a fairly straightforward boilerplate to update.

@YohDeadfall has done a lot of work on improving SPI's safety and it's greatly appreciated!

What's Changed

cargo-pgrx

• fix a deadlock in cargo pgrx install during get_git_hash() by @eeeebbbbrrrr in #1935
• cargo pgrx test --runas envar passing by @eeeebbbbrrrr in #1674
• Search for sql upgrade scripts relative to the package manifest by @tristan957 in #1979

Build System

• use allowlist_file for bindgen by @usamoi in #1922
• add pg_config --libdir to linker search path by @usamoi in #1932
• lock patch version of pgrx-bindgen by @usamoi in #1939
• Introduce a blocklist of "yanked" Postgres versions by @eeeebbbbrrrr in #1950
• Make sure bindgen gets the cppflags even if we aren't using macOS by @thomcc in #1336

SPI

• Made SPI query arguments type safe by @YohDeadfall in #1858
• Changed args of prepare methods to be slices by @YohDeadfall in #1933
• Added connect_mut for data changing SPI operations by @YohDeadfall in #1913

General pgrx-pg-sys Interfaces

• Allow creating Oid from a u32 in a const context by @syvb in #1943
• Add utils/acl.h by @daamien in #1945
• Add catalog/catalog.h by @daamien in #1946
• Added oids_of! macro by @YohDeadfall in #1879
• Port bufpage.h functions by @rebasedming in #1982

Bug Fixes

• Check wakeup_flags from wait_latch function to exit on WL_POSTMASTER_DEATH by @var77 in #1938

Overall Code Cleanup

• refactor: remove redundant references (&) by @hamirmahal in #1941
• fix warnings by @usamoi in #1948
• Updating readme.md by @ChronicallyJD in #1949
• style: simplify some statements for readability by @hamirmahal in #1962
• docs: fix pgx info in cargo-pgrx README by @mrdrivingduck in #1953
• Updated expected UI test outputs by @YohDeadfall in #1981
• Fix "about" info for cross subcommand by @mjgarton in #1974
• update dependencies and fix compilation issues by @eeeebbbbrrrr in #1983

Thanks!

Thanks to the community, past, present, and future. Especially to our new contributors...

New Contributors

• @var77 made their first contribution in #1938
• @ChronicallyJD made their first contribution in #1949
• @mrdrivingduck made their first contribution in #1953
• @tristan957 made their first contribution in #1979
• @mjgarton made their first contribution in #1974

Full Changelog: v0.12.7...v0.13.0