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

Release v1.6.2

What's Changed

• refactor: convert multi-pass to single-pass in plan module by @tianzhou in #245
• fix: function to function dependency by @tianzhou in #247
• fix: topological sort for modified tables' constraint dependencies by @tianzhou in #249
• fix: skip revoking privileges covered by default privileges (#250) by @tianzhou in #251
• fix: revoke default privilege grants on new tables by @tianzhou in #257
• fix: function dependencies by @mistermoe in #258
• fix: missing parentheses in CREATE POLICY USING clause output by @tianzhou in #260
• fix: domain CHECK constraint ordering with function dependencies by @mistermoe in #261
• feat: add --no-comments flag to dump command by @tianzhou in #263
• fix: incorrect parentheses in partial index WHERE clause with IN and AND by @tianzhou in #265
• fix: composite FK referenced column order when FK order differs from table column order (#266) by @curthasselschwert in #267
• fix: handle dependent views when recreating materialized views by @tianzhou in #272
• fix(internal): apply QuotedIdentifier in more cases by @PadenZach in #274
• fix: varchar IN check constraints generating invalid SQL by @tianzhou in #273

New Contributors

• @mistermoe made their first contribution in #258
• @curthasselschwert made their first contribution in #267
• @PadenZach made their first contribution in #274

Full Changelog: v1.6.1...v1.6.2

Release v1.6.1

What's Changed

• fix: add SearchPath comparison to functionsEqualExceptAttributes by @asonawalla in #235
• fix: include FOR ROLE in ALTER DEFAULT PRIVILEGES DDL by @asonawalla in #236
• refactor: review ir module to enhance code readability by @tianzhou in #237
• feat: add support for column-level GRANT privileges by @asonawalla in #238
• fix: ensure embedded postgres cleanup in TestMain by @asonawalla in #239
• fix: emit REVOKE statements before DROP statements by @asonawalla in #243
• fix: include column comments when adding new columns by @asonawalla in #242
• fix: handle BEGIN ATOMIC syntax in SQL-standard function bodies by @tianzhou in #244

Full Changelog: v1.6.0...v1.6.1

Release v1.6.0

What's Changed

• feat: add support for FORCE ROW LEVEL SECURITY by @tianzhou in #215
• fix: preserve interval type casts in function parameter defaults (#216) by @tianzhou in #217
• fix: preserve schema qualifiers in column default type casts by @tianzhou in #219
• fix: normalize policy expression schema qualifiers by @tianzhou in #222
• docs: supabase declarative schema vs pgschema by @tianzhou in #223
• fix: normalize table references in policy expressions by @asonawalla in #226
• chore: adjust policy table reference test case by @tianzhou in #228
• fix: defer FK constraints until all table batches are created by @tianzhou in #229
• feat: COMMENT ON for function and stored procedure by @tianzhou in #230
• feat: support SET search_path for functions by @tianzhou in #231
• feat: default privilege by @tianzhou in #232
• feat: support GRANT/REVOKE for schema objects by @tianzhou in #233

New Contributors

• @asonawalla made their first contribution in #226

Full Changelog: v1.5.1...v1.6.0

Release v1.5.1

What's Changed

• fix: support overloaded functions and procedures in dump (#191) by @tianzhou in #192
• fix: generated column on public schema by @tianzhou in #201
• fix: partial index by @tianzhou in #202
• fix: quote policy names in DDL output by @tianzhou in #204
• fix: type topological sort by @tianzhou in #205
• fix: include public in search_path for extension type resolution by @tianzhou in #208
• fix: add USING clause for text-to-enum type conversions by @tianzhou in #209
• Fix index name mutation for identifiers containing dots by @tianzhou in #213
• feat: release darwin/amd64 binaries by @alecthomas in #199

New Contributors

• @alecthomas made their first contribution in #199

Full Changelog: v1.5.0...v1.5.1

Release v1.5.0

What's Changed

• fix: default column value function order by @tianzhou in #175
• Minor Update to Claude.md by @Adam-Mustafa in #176
• Add limit to missing "smart-quote" Keywords by @Adam-Mustafa in #177
• fix: track LEAKPROOF and SECURITY DEFINER by @tianzhou in #181
• Add list of postgres reserved keywords to "smart-quote" keyword list by @Adam-Mustafa in #178
• chore: refine quotation by @tianzhou in #182
• chore: generated_column test case by @tianzhou in #184
• feat: support PG 18 by @tianzhou in #187
• fix: materialized view drop order that depends on table by @tianzhou in #188
• chore: fix materialized view recreate summary by @tianzhou in #189

New Contributors

• @Adam-Mustafa made their first contribution in #176

Full Changelog: v1.4.3...v1.5.0

Release v1.4.3

What's Changed

• fix: constraint name quoting by @tianzhou in #165
• fix: properly drop temporary NOT NULL constraint by @sam-mosleh in #166
• refactor: consolidate uk test case by @tianzhou in #168
• refactor: consolidate pk test case by @tianzhou in #169
• chore: add a fk test case by @tianzhou in #170
• fix: preserve constraints to ignored tables in multi-file dumps by @tianzhou in #171

New Contributors

• @sam-mosleh made their first contribution in #166

Full Changelog: v1.4.2...v1.4.3

Release v1.4.2

What's Changed

• chore: consolidate DSN construction by @tianzhou in #142
• fix: non-primitive types qualified by @tianzhou in #145
• fix: extension qualifier by @tianzhou in #146
• Revert "fix: extension qualifier (#146)" by @tianzhou in #147
• fix: type/extension from different schema by @tianzhou in #151
• chore: log sql statement when apply/plan when —debug by @tianzhou in #152
• fix: drop trigger/function order by @tianzhou in #154
• fix: normalize schema-qualified identifiers in SQL strings by @p-c-h-b in #157
• chore: enhance plan schema name replacer by @tianzhou in #159
• fix: normalize schema qualifier in function arguments by @tianzhou in #160
• fix: defer FK constraints when referenced tables don't exist yet by @p-c-h-b in #156
• chore: address review comments by @tianzhou in #162
• Fix normalization of custom array type by @isaacparker0 in #163
• chore: refine custom array type fix by @tianzhou in #164

New Contributors

• @p-c-h-b made their first contribution in #157
• @isaacparker0 made their first contribution in #163

Full Changelog: v1.4.1...v1.4.2

Release v1.4.1

Push a clean release (this is the essentially the same version as v1.4.0, v1.4.0 was re-pushed causing checksum mismatch when installing via Go)

Key Changes

• To cover complex schema, use embedded Postgres database as the default. For certain cases such as #121 #122, allow user to supply an external plan database. See plan DB for more info.

• Fix installation #100 #128

What's Changed

• feat: named constraint by @tianzhou in #79
• fix: index name quotation by @tianzhou in #81
• fix: view logic expr by @tianzhou in #87
• fix: generate_column_not_null by @tianzhou in #88
• fix: view array operator by @tianzhou in #89
• refactor: simiplify formatter by @tianzhou in #90
• chore: do not strip type cast by @tianzhou in #95
• fix: varchar normalization by @tianzhou in #96
• fix: add schema qualifier to cross-schema foreign key references (#94) by @tianzhou in #97
• feat: remove argument and signature by @tianzhou in #98
• feat: enhance function default parameter support and fix parsing bugs by @tianzhou in #99
• fix: cross schema table reference in view by @tianzhou in #105
• fix: ignored objects should be excluded from fingerprint calc by @tianzhou in #108
• refactor: use embedded PostgreSQL for desired state validation in pla… by @tianzhou in #109
• fix: table function by @tianzhou in #110
• chore: merge test case by @tianzhou in #112
• chore: add NULLIF test case by @tianzhou in #113
• chore: view_cte test case by @tianzhou in #114
• chore: view subquery test case by @tianzhou in #115
• refactor: simplify normalizer and remove formatter by @tianzhou in #111
• chore: simplify inspector by @tianzhou in #116
• chore: simplify view comparison and remove pg_query_go by @tianzhou in #117
• chore: remove ir release module and update doc by @tianzhou in #118
• chore: remove cgo since we removed pg_query_go by @tianzhou in #119
• refactor: simplify embeded pg by @tianzhou in #120
• fix: schema qualifer reference by @tianzhou in #124
• fix: function dump default by @tianzhou in #126
• feat: add external database support for plan command by @tianzhou in #129
• docs: plan external db by @tianzhou in #130
• feat: add plan db option to apply command --file mode by @tianzhou in #131
• fix: index operators by @tianzhou in #134
• chore: add dump test case to verify index sorted order by @tianzhou in #135
• chore: suppress test output by @tianzhou in #136
• chore: drop PostgreSQL 14 support by @tianzhou in #137
• chore: skip pg_get_viewdef related test for PG 14, 15 by @tianzhou in #139
• fix: do not use harded-coded version string by @tianzhou in #140

Full Changelog: v1.3.0...v1.4.0

Release v1.4.0

Key Changes

• To cover complex schema, use embedded Postgres database as the default. For certain cases such as #121 #122, allow user to supply an external plan database. See plan DB for more info.

• Fix installation #100 #128

What's Changed

• feat: named constraint by @tianzhou in #79
• fix: index name quotation by @tianzhou in #81
• fix: view logic expr by @tianzhou in #87
• fix: generate_column_not_null by @tianzhou in #88
• fix: view array operator by @tianzhou in #89
• refactor: simiplify formatter by @tianzhou in #90
• chore: do not strip type cast by @tianzhou in #95
• fix: varchar normalization by @tianzhou in #96
• fix: add schema qualifier to cross-schema foreign key references (#94) by @tianzhou in #97
• feat: remove argument and signature by @tianzhou in #98
• feat: enhance function default parameter support and fix parsing bugs by @tianzhou in #99
• fix: cross schema table reference in view by @tianzhou in #105
• fix: ignored objects should be excluded from fingerprint calc by @tianzhou in #108
• refactor: use embedded PostgreSQL for desired state validation in pla… by @tianzhou in #109
• fix: table function by @tianzhou in #110
• chore: merge test case by @tianzhou in #112
• chore: add NULLIF test case by @tianzhou in #113
• chore: view_cte test case by @tianzhou in #114
• chore: view subquery test case by @tianzhou in #115
• refactor: simplify normalizer and remove formatter by @tianzhou in #111
• chore: simplify inspector by @tianzhou in #116
• chore: simplify view comparison and remove pg_query_go by @tianzhou in #117
• chore: remove ir release module and update doc by @tianzhou in #118
• chore: remove cgo since we removed pg_query_go by @tianzhou in #119
• refactor: simplify embeded pg by @tianzhou in #120
• fix: schema qualifer reference by @tianzhou in #124
• fix: function dump default by @tianzhou in #126
• feat: add external database support for plan command by @tianzhou in #129
• docs: plan external db by @tianzhou in #130
• feat: add plan db option to apply command --file mode by @tianzhou in #131
• fix: index operators by @tianzhou in #134
• chore: add dump test case to verify index sorted order by @tianzhou in #135
• chore: suppress test output by @tianzhou in #136
• chore: drop PostgreSQL 14 support by @tianzhou in #137
• chore: skip pg_get_viewdef related test for PG 14, 15 by @tianzhou in #139
• fix: do not use harded-coded version string by @tianzhou in #140

Full Changelog: v1.3.0...v1.4.0