pg-schema-diff icon indicating copy to clipboard operation
pg-schema-diff copied to clipboard

Go library for diffing Postgres schemas and generating SQL migrations

Results 70 pg-schema-diff issues
Sort by recently updated
recently updated
newest added

- Split SQL generators into their own files - Split schema diff definitions into their own file - Split the schema struct definitions into a separate file from where the...

tech debt

It is not always desirable to create/drop indexes concurrently, so it should be possible to switch it off.

Columns on partitions can have their own nullability that is different from the parent. We do not support changing their nullability with minimal locks because we don't yet support local...

There is a weird quirk of our graph system, where if a -> b and b -> c and b does-not-exist, b will be implicitly created s.t. a -> b...

Provide comments to confusing SQL blocks. This will help users more easily interpret what is going on. At some point, we might want to support statement "groups", where we can...

Add Postgres 16 to Acceptance Test Matrix

Currently, if switching between incompatible types with a FK, plan validation will error. We need to identify if types are incompatible and drop and re-add the FK This is probably...

enhancement

If a migration is canceled, temporary databases will be orphaned. This problem should be pretty rare. Temp db factories should clean up (some) orphaned databases each time they create a...

enhancement