v3.3.4

What's Changed

• Fix DuckDB identifier and struct value quoting for special characters… by @sfc-gh-dachristensen in #348

Full Changelog: v3.3.3...v3.3.4

v3.3.2

What's changed

• Fix a performance issue in Iceberg commits with a large number of data files

v3.3.1

Small bug fixes and build and CI improvements

Full change list

• Make linting its own workflow by @sfc-gh-npuka in #317
• Export GetNotShippableDescription and CollectNotShippableObjects by @sfc-gh-okalaci in #318
• Fix NOT NULL bypass when clamp mode converts values to NULL by @sfc-gh-npuka in #316
• Upload postgres log artifacts to CI by @sfc-gh-dachristensen in #323
• Pin PGINDENT_PG_VERSION by @sfc-gh-npuka in #325
• Bump max_replication_slots in CI by @sfc-gh-dachristensen in #324
• Fix double-free in WaitForResult when pgduck_server crashes mid-query by @sfc-gh-dachristensen in #326
• Fix TIMETZ corruption in Iceberg pushdown/snapshot writes by @sfc-gh-okalaci in #329
• Bound iceberg manifest-rewrite memory under high-churn workloads by @sfc-gh-okalaci in #334
• Allow per-table opt-out of autovacuum data-file compaction by @sfc-gh-okalaci in #335
• Add PAM support to PostgreSQL compile flags and Docker images by @sfc-gh-dachristensen in #313
• iceberg: preserve required as NOT NULL when auto-detecting columns by @timmclaughlin in #330

Full Changelog: v3.3.0...v3.3.1

v3.3.0

What's Changed

• Move CachedExtensionIds and SPI helpers to pg_extension_base by @sfc-gh-okalaci in #164
• Fix logical replication error when dropping Iceberg tables by @sfc-gh-okalaci in #171
• Expose null_padding option for CSV by @sfc-gh-mslot in #155
• Fix substring_pg crash on macOS due to long vs int64_t type mismatch by @sfc-gh-okalaci in #177
• Remove max CSV line size limitation by @sfc-gh-mslot in #174
• Add missing catalog to the object store catalog by @sfc-gh-okalaci in #178
• Support additional Iceberg REST API authentication method by @sfc-gh-mslot in #176
• Introduce OidListToArray by @sfc-gh-agedemenli in #181
• Add GUC to disable vended credentials header for REST catalog by @sfc-gh-okalaci in #184
• Allow long-form Azure URLs by @sfc-gh-mslot in #187
• Make TupleDescToDuckDBColumnsMap so that other extensions can use by @sfc-gh-okalaci in #192
• Make FindUnreferencedFilesAmongHTABs function public by @sfc-gh-mslot in #193
• Use the specified VCPKG_VERSION 2025.10.17; change jdk21 to 21.0.10 by @sfc-gh-npuka in #189
• Make TupleDescToColumnMapForWrite public by @sfc-gh-okalaci in #199
• Provide more common code fore ReadCSV by @sfc-gh-okalaci in #200
• Parallelize upload of metadata files during commit by @sfc-gh-mslot in #197
• Use pyspark conditionally in the tests by @sfc-gh-okalaci in #202
• Re-enable PG18 tests in test_base_worker_launcher.py by @sfc-gh-mslot in #204
• Add pg_lake upgrade path from 2.4-1; incorporate same fixes here by @sfc-gh-dachristensen in #196
• Update installation and test docs by @sfc-gh-npuka in #207
• Cache in-progress table visibility to avoid SPI per file write by @sfc-gh-okalaci in #210
• Add function to run attached worker with query results by @sfc-gh-mslot in #213
• Allow Iceberg table creation in extensions by @sfc-gh-mslot in #216
• Add test coverage for REPEATABLE READ and SERIALIZABLE isolation levels by @tanvinkalra in #201
• Make sure to create data file temp table with extension user privilege by @sfc-gh-abozkurt in #219
• Pushdown initcap function by @sfc-gh-npuka in #208
• Fix test teardown hangs by adding timeouts to process and thread cleanup by @sfc-gh-mslot in #224
• Fix compiler warnings by @sfc-gh-npuka in #228
• Put sample data under parent folder by @sfc-gh-abozkurt in #231
• Reorganize test_common helpers by @sfc-gh-abozkurt in #232
• pgduck_server handles sigint/sigterm gracefully by @sfc-gh-abozkurt in #229
• Fixes pushdown with constant in grouping by @sfc-gh-abozkurt in #238
• Support Postgres interval types as structs in Iceberg by @sfc-gh-mslot in #220
• Fix flaky test_set_operation_pushdown by @sfc-gh-mslot in #243
• Fix insert..select and copy from pushdown for nested types by @sfc-gh-abozkurt in #241
• Support timetz in iceberg tables by @sfc-gh-abozkurt in #239
• Fix BC date/timestamp via PGDuckSerialize + ISO write to Iceberg by @sfc-gh-abozkurt in #249
• Unbounded numeric stays as numeric in PG schema, still writes as DECIMAL(38,9) to Iceberg by @sfc-gh-abozkurt in #252
• Support unsupported numeric as double by default in Iceberg tables by @sfc-gh-abozkurt in #257
• Expand permissions for iceberg tables, filter REST iceberg tables by @sfc-gh-dachristensen in #259
• Clamp numeric NaN as NULL at postgres_scanner by @sfc-gh-abozkurt in #258
• Use index scan in CheckObjectCreatedByLakeInternal by @sfc-gh-npuka in #261
• Fix crash in hide_lake_objects for MERGE on catalog tables by @sfc-gh-npuka in #265
• Remove pre-PG16 compat code and bump min version checks by @sfc-gh-npuka in #266
• Add @stage shorthand for common staging bucket by @sfc-gh-mslot in #245
• Add per-table max_snapshot_age option for Iceberg tables by @sfc-gh-mslot in #244
• Add automated installation script and improve documentation by @sfc-gh-mslot in #225
• Add the option of restart base workers after N milliseconds by @sfc-gh-mslot in #205
• Fix CTAS in SPI assert failure (on top of 254) by @sfc-gh-mslot in #260
• Use heavy asserts in CI; fix heavy assert for NaN/Inf float column bounds by @sfc-gh-npuka in #262
• Switch to upstream DuckDB Azure by @sfc-gh-mslot in #256
• Error or clamp out-of-range values via iceberg table option by @sfc-gh-abozkurt in #250
• Mark file options as null when not set by @sfc-gh-abozkurt in #272
• Support one-shot extension workers by @sfc-gh-dachristensen in #270
• Put trailing slash removal logic into StripTrailingSlash helper by @sfc-gh-npuka in #275
• Convert unsupported numeric in nested types to double in iceberg tables by @sfc-gh-abozkurt in #273
• Fix nested type clamping in iceberg tables by @sfc-gh-abozkurt in #274
• Add limit on total number of position deletes by @sfc-gh-mslot in #268
• Fix iceberg format error for unbounded numerics by @sfc-gh-abozkurt in #280
• Re-upgrade to duckdb 1.4.4 by @sfc-gh-dachristensen in #283
• Add a NULL check in GetIcebergMetadataLocation by @sfc-gh-mslot in #282
• Fix double roundtrip by @sfc-gh-abozkurt in #284
• Add 2-character prefix to Iceberg filenames by @sfc-gh-mslot in #287
• Add missingOk to DeregisterBaseWorker*() routines by @sfc-gh-dachristensen in #292
• Tweak install.sh by @sfc-gh-mslot in #281
• postgres_scanner: Read composite type info by @sfc-gh-abozkurt in #291
• Pushdown interval by @sfc-gh-abozkurt in #290
• Refactor http request retry logic + fix token expired bug by @sfc-gh-npuka in #278
• Clamp multidimensional arrays to NULL by @sfc-gh-abozkurt in #289
• Error by default for out of range values in iceberg by @sfc-gh-abozkurt in #294
• Add routine to get running worker pid by @sfc-gh-dachristensen in #295
• Fix composite scanner composite patch by @sfc-gh-abozkurt in #296
• Make interval fields non-required by @sfc-gh-mslot in #298
• Cache composite TupleDescs in HTAB across COPY lifetime by @sfc-gh-dachristensen in #285
• Use cmake build system for Avro, fixes build with Ninja gen by @sfc-gh-vparakh in #302
• Fix: add --break-system-packages for pipenv install on macOS by @sfc-gh-vparakh in #301
• Revert "Cache TupleDesc per composite column in copy_dest_receive" by @sfc-gh-okalaci in #303
• Export write tupledesc by @sfc-gh-abozkurt in #306
• Fix type mismatch in TimestampDifference and off-by-1 in GUC check by @sfc-gh-npuka in #305
• Fix CI check-indent and pin pg18 version + Fix repo formatting by @sfc-g...

v3.2.2

What's Changed

• Allow azure:// as a URL prefix #187
• Add @STAGE shorthand for common staging bucket #246
• Fix crash in hide_lake_objects for MERGE on catalog tables #265

Full Changelog: v3.2.1...v3.2.2

v3.2.0

What's Changed

• Bump all versions to 3.2 by @sfc-gh-okalaci in #158
• Fix compiler warnings by @sfc-gh-mslot in #153
• Fix --cache_on_write_max_size CLI parsing for values > 2GB by @sfc-gh-abozkurt in #163
• Add a compile-time flag for delta support by @sfc-gh-mslot in #161
• Add empty overlay port for OpenSSL by @sfc-gh-mslot in #162
• Fix an issue with preserve_insertion_order getting enabled by @sfc-gh-mslot in #165
• Add AWS extension to extension_config.cmake by @sfc-gh-mslot in #167

Full Changelog: v3.1.0-rc2...v3.2.0

v3.1.0 RC1

What's Changed (since initial release)

• Update to DuckDB 1.4.2 in #54
• Fix a bug with data file visibility during update/delete #86
• Fix a bug where background worker limits are miscounted #31
• Fix a bug with rewriting trigonometric funcs with degrees arg in #57
• Fix an issue that Docker can't access AWS credential by @tsho in #46
• Improve Docker developer experience by @kameshsampath in #92
• Use public HTTPS to clone pg_lake repo in Docker by @kruckenb in #34
• Documentation fixes by @alejandrodnm @seandavi @louis-auzou in #38
• Pushdown encode/decode for base64 and hex in #44
• Pushdown time(tz) casts in #69
• Pushdown hyperbolic functions #78
• Refactor make targets in #12 #95 #99
• Add a GUC to log HTTP traffic in #71
• Increment HTTP Timeouts #93
• Experimental: Writable Iceberg tables with REST catalog support in #68

Full Changelog: https://github.com/Snowflake-Labs/pg_lake/commits/v3.1.0-rc1