Postgres Pro
Downloads
Home   >   mailing lists

Re: using index to speedup add not null constraints to a table - Mailing list pgsql-hackers

From jian he
Subject Re: using index to speedup add not null constraints to a table
Date
Msg-id CACJufxHdR0Rd4-v78XhH+xNungof=zQrcTZK0GSN16zoNHWdHg@mail.gmail.com
Whole thread Raw
In response to Re: using index to speedup add not null constraints to a table  (jian he <jian.universality@gmail.com>)
Responses Re: using index to speedup add not null constraints to a table
List pgsql-hackers
Tree view 
On Fri, Apr 18, 2025 at 4:07 PM jian he <jian.universality@gmail.com> wrote:
>
> I don't have any good ideas to do the regress tests.
> I use
>                 ereport(NOTICE,
>                         errmsg("all not-null constraints on relation
> \"%s\" are validated by index scan",
>                                 RelationGetRelationName(oldrel)));
> to do the tests.
>
for tests, just found out i can imitate
src/test/modules/test_misc/t/001_constraint_validation.pl,

So I created a file:
src/test/modules/test_misc/t/008_indexscan_validate_notnull.pl
for TAP tests.
Attachment

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: domain over virtual generated column
Next
From: Andrey Borodin
Date:
Subject: Re: Cancel problems of query to pg_stat_statements