Release v1.11.1

What's Changed

• fix: use DROP MATERIALIZED VIEW for materialized dependents during recreate (#415) by @tianzhou in #463
• fix: support CREATE/DROP/ALTER AGGREGATE in diff and dump (#416) by @tianzhou in #464
• fix: preserve schema-qualified functions in RLS policy expressions (#427) by @tianzhou in #465
• fix: pre-drop recreated views before dependent column drops (#444) by @tianzhou in #466
• fix: render policy and constraint expressions with table schema search_path (#449) by @tianzhou in #467
• feat: hint at extension dependency when plan fails with missing object errors (#436) by @tianzhou in #468
• fix: recreate dependent FKs when a referenced unique/PK constraint is replaced (#439) by @tianzhou in #470
• fix: strip double-quotes from extracted sequence name in SERIAL ownership detection by @ayusssmaan in #469
• feat: add support for index storage parameters (reloptions) by @ayusssmaan in #478
• style: gofmt struct alignment in Index (#478 followup) by @tianzhou in #482
• feat: add support for trigger comments, trigger enabled/disabled state, and sequence comments by @ayusssmaan in #479
• fix: detect comment/state-only drift on view triggers (#479 followup) by @tianzhou in #483
• docs: document index storage params, trigger comment/state, sequence comments by @tianzhou in #484
• fix: preserve AS RESTRICTIVE on CREATE POLICY (#477) by @tianzhou in #485
• fix: converge trigger WHEN expressions with same-schema enum casts (#481) by @tianzhou in #486
• fix: skip partition-clone child triggers in dump (#472) by @tianzhou in #487
• fix: order function recreation after dependent view recreation (#480) by @tianzhou in #488
• test: run full suite only on latest PG, essential subset on 14-17 by @tianzhou in #489

Full Changelog: v1.11.0...v1.11.1

Release v1.11.0

What's Changed

• feat: add constraints section to .pgschemaignore (#429, #447) by @tianzhou in #452
• fix nix packaging by @vkcku in #440
• feat: add triggers section to .pgschemaignore (#407) by @tianzhou in #453
• fix: order CREATE VIEW after ALTER TABLE ADD COLUMN within a plan (#414) by @PadenZach in #417
• refactor: tidy up #414 view-deferral followups by @tianzhou in #454
• fix: quote mixed-case trigger names and FK referenced column names in… by @ayusssmaan in #451
• fix: complete mixed-case identifier quoting in generated DDL (#451 followup) by @tianzhou in #455
• fix: detect numeric precision/scale changes in column diff (#362) by @tianzhou in #456
• fix: preserve DEFERRABLE on UNIQUE/PRIMARY KEY constraints (#404) by @tianzhou in #458
• fix: emit non-concurrent CREATE INDEX on partitioned parents (#418) by @tianzhou in #459
• fix: skip internal per-partition FK constraints in dump (#409) by @tianzhou in #460
• fix: quote mixed-case table and column names in CREATE SEQUENCE OWNED BY clause by @ayusssmaan in #457
• feat: log when no .pgschemaignore file is found (#419) by @tianzhou in #461
• fix: quote mixed-case user-defined type names in column type references (#422) by @tianzhou in #462

New Contributors

• @vkcku made their first contribution in #440
• @ayusssmaan made their first contribution in #451

Full Changelog: v1.10.0...v1.11.0

Release v1.10.0

What's Changed

• fix: show error location with SQL context when plan fails by @tianzhou in #394
• fix: table-level CHECK constraints with IS NOT NULL silently omitted from dump (#396) by @tianzhou in #398
• fix: plan fails with schema-qualified references in function bodies (#399) by @tianzhou in #400
• fix: name-typed columns dumped as char[] by @ivgiuliani in #411
• Preserve UNIQUE NULLS NOT DISTINCT by @ivgiuliani in #413
• feat: add Nix flake and package by @Rooffeell in #381
• Add support for UNLOGGED tables by @ivgiuliani in #424
• refactor: refactor the release workflow's test job to use a GitHub Actions matrix strategy, running PostgreSQL 14-18 tests in parallel instead of sequentially. by @NFUChen in #432
• feat: add validation for file extensions in apply command by @NFUChen in #434
• Add support for indexes section in .pgschemaignore by @guillaume86 in #441
• fix: preserve length modifier in varchar(n)[] array columns (#420) by @vytautas-karpavicius in #438

New Contributors

• @ivgiuliani made their first contribution in #411
• @Rooffeell made their first contribution in #381
• @NFUChen made their first contribution in #432
• @guillaume86 made their first contribution in #441
• @vytautas-karpavicius made their first contribution in #438

Full Changelog: v1.9.0...v1.10.0

Release v1.9.0

What's Changed

• fix: preserve nested function calls in RLS policy expressions (#377) by @tianzhou in #378
• fix: strip temp schema prefix from GRANT/REVOKE function signatures (#376) by @tianzhou in #379
• fix: skip FK constraint drop when referenced table is dropped with CASCADE (#382) by @tianzhou in #383
• fix: skip constraint drop when DROP COLUMN already removes it by @cysp in #388
• ci: upgrade GitHub Actions toolchain for runner and alpine linux compatibility by @gclove in #387
• fix: preserve INCLUDE columns on CREATE INDEX (#385) by @tianzhou in #390
• fix: support CHECK constraints without columns and NO INHERIT modifier (#386) by @tianzhou in #391
• fix: skip privileges for ignored objects in .pgschemaignore (#392) by @tianzhou in #393

New Contributors

• @cysp made their first contribution in #388
• @gclove made their first contribution in #387

Full Changelog: v1.8.0...v1.9.0

Release v1.8.0

What's Changed

• fix: support view options (security_invoker, security_barrier) in dump and plan by @tianzhou in #352
• feat: add --sslmode flag and PGSSLMODE env var support by @tianzhou in #353
• fix: strip quotes from type names in view dependency detection by @FFX3 in #337
• fix: support NULLS NOT DISTINCT on unique indexes (#355) by @tianzhou in #356
• fix: handle empty search_path and preserve schema qualifiers in function bodies (#354) by @tianzhou in #357
• fix: preserve schema qualifiers in function/procedure bodies (#354) by @tianzhou in #358
• fix: strip schema qualifiers from custom types in RETURNS TABLE (#360) by @tianzhou in #361
• feat: support PostgreSQL 18 temporal constraints (WITHOUT OVERLAPS / PERIOD) by @kenchan0130 in #365
• fix: correct LANGUAGE for overloaded functions with mixed languages (#368) by @tianzhou in #370
• fix: defer cross-table policy creation until all tables exist (#373) by @tianzhou in #374
• fix: use dedicated connection in ApplySchema to preserve search_path by @tianzhou in #375
• fix: preserve string literals during schema qualification stripping (#371) by @tianzhou in #372

New Contributors

• @FFX3 made their first contribution in #337
• @kenchan0130 made their first contribution in #365

Full Changelog: v1.7.4...v1.8.0

Release v1.7.4

What's Changed

• fix: filter default privileges by role membership to fix Supabase regression (#323) by @tianzhou in #334
• fix: rewrite SET search_path in function definitions for temp schema (#335) by @tianzhou in #336
• fix: use target database user for embedded postgres in plan command (#303) by @tianzhou in #338
• chore: update Claude Code skills for development workflows by @tianzhou in #341
• feat: add support for privileges in .pgschemaignore (#339) by @tianzhou in #340
• feat: add support for trigger UPDATE OF columns (#342) by @tianzhou in #344
• fix: clean up leaked cluster-level roles in TestIgnorePrivileges by @tianzhou in #346
• feat: add support for view reloptions (security_invoker, security_barrier) (#343) by @tianzhou in #347
• fix: preserve array type casts in policy expressions (#345) by @tianzhou in #348

Full Changelog: v1.7.3...v1.7.4

Release v1.7.3

What's Changed

• fix: exclude DiffSource interface field from JSON serialization (#305) by @tianzhou in #309
• fix: preserve dependency order for views in multi-file dump (#307) by @tianzhou in #310
• fix: use DROP+CREATE for views with column changes instead of CREATE OR REPLACE (#308) by @tianzhou in #311
• fix: quote camelCase column names in online NOT NULL rewrite DDL (#313) by @tianzhou in #315
• fix: normalize view definitions to strip same-schema qualifiers (#314) by @tianzhou in #316
• fix: scope pg_class joins by relnamespace to prevent cross-schema comment misattribution (#318) by @tianzhou in #319
• fix: quote reserved keywords after schema prefix stripping in function bodies (#320) by @tianzhou in #322
• fix: order REVOKE before GRANT when transitioning between table and column privileges (#324) by @tianzhou in #325
• fix: DROP function before CREATE when return type or param names change (#326) by @tianzhou in #327
• fix: add 13 missing reserved keywords to identifier quoting (#328) by @tianzhou in #330
• docs: update CLAUDE.md, skills, and add PostgreSQL grammar reference files by @tianzhou in #331

Full Changelog: v1.7.2...v1.7.3

Release v1.7.2

What's Changed

• fix: preserve typmod for extension types in column type resolution (#295) by @tianzhou in #297
• fix: sort object names in multi-file dump for deterministic include order (#299) by @tianzhou in #301
• fix: defer functions with view dependencies to after view creation (#300) by @tianzhou in #302

Full Changelog: v1.7.1...v1.7.2

Release v1.7.1

What's Changed

• fix: truncated function signatures in GRANT statements (#275) by @tianzhou in #288
• fix: EXCLUDE constraint incorrectly dumped as regular INDEX (#281) by @tianzhou in #289
• fix: spurious plan changes for column defaults with schema-qualified functions (#283) by @tianzhou in #290
• fix: reserved keyword not quoted in online rewrite DDL (#286) by @tianzhou in #291
• fix: INSTEAD OF triggers on views missing from dump (#287) by @tianzhou in #292
• fix: add connect_timeout and ping timeout to database connections by @tianzhou in #293
• fix: strip current schema qualifier from function/procedure bodies in dump (#252) by @tianzhou in #294

Full Changelog: v1.7.0...v1.7.1

Release v1.7.0

Important: We have moved repo from pgschema/pgschema to pgplex/pgschema

What's Changed

• fix: multiple statements from the same column by @sam-mosleh in #278
• fix: track altering identities by @sam-mosleh in #282

Full Changelog: v1.6.2...v1.7.0