On Sun, 08 Nov 2026, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> The test query alone would have been fine, but without a
> straightforward repair recipe, I'm not sure how useful it is. I don't
> want to expend a large amount of note space on a problem that likely
> affects very few people. Maybe we could stop at offering the ALTER
> TABLE commands, and leave people to cope with finding any NULLs on
> their own?
Yes, I think even the test query could be enough, and then simply
mentioning that the constraint has to be fixed or dropped.