Changelog
All notable changes to the Snowflake extension are documented here.
2.5.0 (unreleased)
Added
- PG18 support: added a PG18 test configuration and adjusted the Docker build to skip LLVM bitcode compilation on PG18.
Changed
- Adopted three-digit (
MAJOR.MINOR.PATCH) versioning. The extension version is now2.5.0.
Fixed
- Fixed dump/restore of snowflake-converted sequences.
convert_sequence_to_snowflake()previously leftMAXVALUEat(old last_value + 1), butsnowflake.nextval()bypassesMAXVALUEand writes snowflake-sized values, sopg_dumpcould emit asetval()that failed to restore. Sequences are now converted withAS bigint MAXVALUE 9223372036854775807, and sequences converted by earlier versions are auto-repaired on upgrade. (SUP-140) - Fixed the SQL command used to convert sequences to Snowflake.
Security / CI
- Pinned GitHub Actions to full commit SHAs to harden against supply chain attacks.
- Removed
shell=Trueand shell-injection risks from test runner and helper subprocess calls; useshlex.split()for correct argument tokenization. - Fixed a SQL injection warning and a missing parameter in
execute_sqlite_query, and suppressed Bandit B603 warnings on internal test helper subprocess calls. - Fixed the Dockerfile
ARGhandling for newer BuildKit versions. - Updated the copyright year to 2026.