Pgmig

v0.1.1 Feature

This release adds 3 notable features for engineering teams evaluating rollout.

Published 9d Relational Databases

View tool

✓ No known CVEs patched

Read the diff → Tool health → What is this tool? →

✓ No known CVEs patched in this version

Summary

AI summary

Updates feat, refactor, and perf across a mixed release.

Full changelog

What's Changed

fix: clear PgmigApiError when generate() is called from a running event loop by @Apakottur in https://github.com/Apakottur/pgmig/pull/128
feat: support exclusion constraints (EXCLUDE USING ...) by @Apakottur in https://github.com/Apakottur/pgmig/pull/130
feat: sync UNLOGGED tables by @Apakottur in https://github.com/Apakottur/pgmig/pull/129
feat: topologically order composite type create/drop by dependency by @Apakottur in https://github.com/Apakottur/pgmig/pull/131
feat: sync view options (security_invoker, security_barrier, WITH CHECK OPTION) by @Apakottur in https://github.com/Apakottur/pgmig/pull/132
feat: support partition bound changes via detach + re-attach by @Apakottur in https://github.com/Apakottur/pgmig/pull/133
feat: support generated-column expression changes and VIRTUAL columns (PG18) by @Apakottur in https://github.com/Apakottur/pgmig/pull/134
feat: detect and sync column collation changes by @Apakottur in https://github.com/Apakottur/pgmig/pull/135
feat: introspect and diff manually owned sequences (OWNED BY) by @Apakottur in https://github.com/Apakottur/pgmig/pull/137
feat: diff identity column sequence options (start, increment, cache, min/max, cycle) by @Apakottur in https://github.com/Apakottur/pgmig/pull/136
refactor: extract key dataclasses and replace record tuples with explicit types by @Apakottur in https://github.com/Apakottur/pgmig/pull/138
feat: diff table REPLICA IDENTITY by @Apakottur in https://github.com/Apakottur/pgmig/pull/139
feat: recreate partitioned tables on partition key/strategy change by @Apakottur in https://github.com/Apakottur/pgmig/pull/141
feat: diff UNLOGGED sequences (PG15+) by @Apakottur in https://github.com/Apakottur/pgmig/pull/140
refactor: collapse ViewKey into RelationKey by @Apakottur in https://github.com/Apakottur/pgmig/pull/142
feat: order materialized-view dependencies (matview-on-view, matview-on-matview) by @Apakottur in https://github.com/Apakottur/pgmig/pull/143
refactor: add Table.column_by_name and use it for name lookups by @Apakottur in https://github.com/Apakottur/pgmig/pull/144
perf: use a heap for the topological_sort ready set by @Apakottur in https://github.com/Apakottur/pgmig/pull/148
refactor: freeze remaining model dataclasses and dedupe test constant by @Apakottur in https://github.com/Apakottur/pgmig/pull/150
refactor: generalize collect_relations key and simplify function drop order by @Apakottur in https://github.com/Apakottur/pgmig/pull/146
refactor: unify drop-order idiom and generalize the schema-flatten helper by @Apakottur in https://github.com/Apakottur/pgmig/pull/151
perf: cache bundled query reads and order functions by alias by @Apakottur in https://github.com/Apakottur/pgmig/pull/149
refactor: dedup index loaders for tables and matviews by @Apakottur in https://github.com/Apakottur/pgmig/pull/152
fix: run introspection in one REPEATABLE READ snapshot by @Apakottur in https://github.com/Apakottur/pgmig/pull/147
test: cover NULLS NOT DISTINCT for unique constraints and indexes (PG15+) by @Apakottur in https://github.com/Apakottur/pgmig/pull/153
test: cover PG18 temporal constraints (WITHOUT OVERLAPS, PERIOD FK) by @Apakottur in https://github.com/Apakottur/pgmig/pull/154
perf: validate NOT VALID constraints in place instead of drop+re-add by @Apakottur in https://github.com/Apakottur/pgmig/pull/155
feat: alter deferrability in place for foreign keys by @Apakottur in https://github.com/Apakottur/pgmig/pull/156
feat: alter enforced state in place for NOT ENFORCED foreign keys (PG18) by @Apakottur in https://github.com/Apakottur/pgmig/pull/157
perf: skip introspection queries for absent object classes by @Apakottur in https://github.com/Apakottur/pgmig/pull/158