pgroll icon indicating copy to clipboard operation
pgroll copied to clipboard

Add support for `nulls_not_distinct` option in `create_constraint` and `create_index` operations

Open kvch opened this issue 8 months ago • 1 comments

Add support for nulls_not_distinct option in create_constraint and create_index operations for unique constraints and indexes.

NULLS NOT DISTINCT was introduced in PG 15, so I added some conditionals to check if we can retrieve the column from pg_index. Without this function, we get an exception because indnullsnotdisctict does not exist in PG 14.

Closes #730

kvch avatar Mar 24 '25 13:03 kvch

I am converting this to draft for now because we need to rework backfilling process significantly to get this working.

kvch avatar Apr 08 '25 12:04 kvch

Closing because it is outdated.

kvch avatar Jul 14 '25 12:07 kvch