We’re wrapping up our review of the March CommitFest for PostgreSQL 19. This fourth and final article in the series covers the changes related to SQL and to our DEV1 and DEV2 courses.

As a reminder, here’s the plan for our coverage of the final PostgreSQL 19 CommitFest:

Part 5.1 (QPT)

Part 5.2 (DBA1, DBA2)

Part 5.3 (DBA3, DBS)

Part 5.4 (SQL, DEV1, DEV2) -- you are here 🙂

For the earlier CommitFests, see: 2025-07, 2025-09, 2025-11, 2026-01.

Here’s what’s covered:

  • INSERT … ON CONFLICT DO SELECT
  • COPY FROM: replacing invalid values with NULL
  • COPY TO: exporting data in JSON format
  • jsonpath: new string methods
  • IS JSON predicate with domain types
  • postgres_fdw: remote transactions inherit READ ONLY and DEFERRABLE modes
  • Integrity constraints: altering the enforceability of CHECK constraints
  • Integrity constraints: changing the generation expression of virtual columns with CHECK constraints
  • Casting between uuid and bytea, and base32hex format support
  • PL/pgSQL: SELECT … INTO optimization
  • tid_block and tid_offset functions
  • TOAST: lz4 as the default compression method

...