Releases: pgplex/pgschema
Releases · pgplex/pgschema
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
Contributors
alecthomas and tianzhou
Assets 10
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
limitto 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
Contributors
tianzhou and Adam-Mustafa
Assets 9
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
Contributors
tianzhou and sam-mosleh
Assets 9
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
Contributors
tianzhou, p-c-h-b, and isaacparker0
Assets 9
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.
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
Contributors
tianzhou
Assets 9
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.
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
Contributors
tianzhou
Assets 9
Release v1.3.0
What's Changed
- chore: add deb/rpm by @tianzhou in #62
- feat: support CONSTRAINT TRIGGER by @tianzhou in #63
- feat: trigger old table by @tianzhou in #64
- feat: materialized_view_index by @tianzhou in #68
- chore: correct MATERIALIZED VIEW TYPE by @tianzhou in #69
- refactor: dedup index code by @tianzhou in #70
- feat: procedure mode by @tianzhou in #71
- feat: split materialized view from view by @tianzhou in #72
- feat: MATERIALIZED VIEW COMMENT by @tianzhou in #73
- chore: add brew by @tianzhou in #77
Full Changelog: v1.2.1...v1.3.0
Contributors
tianzhou
Assets 9
Release v1.2.1
Contributors
tianzhou
Assets 6
Release v1.2.0
Contributors
tianzhou
Assets 4
Release v1.1.1
What's Changed
- fix: handle permission errors for functions and procedures by @tianzhou in #33
- fix: parentheses handling in CHECK constraint normalization by @grachevko in #35
- fix: proc visibility by @tianzhou in #36
New Contributors
- @grachevko made their first contribution in #35
Full Changelog: v1.1.0...v1.1.1
Contributors
tianzhou and grachevko