Re: using index to speedup add not null constraints to a table
jian he <jian.universality@gmail.com>
From: jian he <jian.universality@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-12-31T16:09:42Z
Lists: pgsql-hackers
Attachments
- v2-0001-using-index-to-speedup-add-not-null-constraint-to.patch (text/x-patch) patch v2-0001
hi. In v1 I didn't do the `git add` for newly created isolation test related files. so the cfbot for isolation tests failed. v1 with index: create index t_idx_ab on t(a,b); we cannot fast add a not-null constraint for column b. with the attached v2 patch, now we can do that. v2, isolation test also adds other session drop index scarenio.