Hi,
On 2025-04-07 17:20:21 +, Álvaro Herrera wrote:
> Allow NOT NULL constraints to be added as NOT VALID
Looks like the test results aren't quite stable across collations:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jay&dt=2025-04-07%2017%3A56%3A49
https://buildfarm.postgresql.o
Allow NOT NULL constraints to be added as NOT VALID
This allows them to be added without scanning the table, and validating
them afterwards without holding access exclusive lock on the table after
any violating rows have been deleted or fixed.
Doing ALTER TABLE ... SET NOT NULL for a column that
