Add support for "online" `NOT NULL` for local nullability on partitions

stripe / pg-schema-diff

Go library for diffing Postgres schemas and generating SQL migrations

MIT License

278 stars 20 forks source link

Add support for "online" `NOT NULL` for local nullability on partitions #88

Open bplunkett-stripe opened 6 months ago

bplunkett-stripe commented 6 months ago

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 check constraints on them.

We might want to solve local check constraints before tackling this.