On Mon, Jul 20, 2026 at 11:47 PM Álvaro Herrera <[email protected]> wrote: > > > Hah, that was quick, thanks! This fails the isolation tests for me > though, with this backtrace: >
I drafted the change a couple of weeks ago but had not sent it out as I was trying to see if I missed something. When I saw your response on the thread, I sent it out as is. > #4 0x00005618d76672d6 in ExceptionalCondition ( > conditionName=conditionName@entry=0x5618d77741a8 "(constr_flags == 0) || > ((flags & INDEX_CREATE_ADD_CONSTRAINT) != 0)", > fileName=fileName@entry=0x5618d7773e58 > "../../pgsql/source/master/src/backend/catalog/index.c", > lineNumber=lineNumber@entry=773) > at ../../pgsql/source/master/src/backend/utils/error/assert.c:65 > #5 0x00005618d7271fd5 in index_create > (heapRelation=heapRelation@entry=0x7f13e9ce85d0, > indexRelationName=indexRelationName@entry=0x5618fe816e58 "uq_val_ccnew", > indexRelationId=indexRelationId@entry=0, > parentIndexRelid=parentIndexRelid@entry=0, > parentConstraintId=parentConstraintId@entry=0, > relFileNumber=relFileNumber@entry=0, > indexInfo=0x5618fe816aa8, indexColNames=0x5618fe6c8d40, > accessMethodId=403, tableSpaceId=0, collationIds=0x5618fe73e2f8, > opclassIds=0x7f13e9cead80, opclassOptions=0x5618fe6c8ea0, > coloptions=0x7f13e9cead9c, stattargets=0x5618fe80d748, reloptions=0, > flags=140, > constr_flags=2, allow_system_table_mods=true, is_internal=false, > constraintId=0x0) at ../../pgsql/source/master/src/backend/catalog/index.c:773 > #6 0x00005618d727248d in index_create_copy > (heapRelation=heapRelation@entry=0x7f13e9ce85d0, flags=flags@entry=140, > oldIndexId=33725, > tablespaceOid=0, newName=0x5618fe816e58 "uq_val_ccnew") at > ../../pgsql/source/master/src/backend/catalog/index.c:1468 > #7 0x00005618d72cbd46 in ReindexRelationConcurrently > (stmt=stmt@entry=0x5618fe712228, relationOid=relationOid@entry=33722, > params=params@entry=0x7ffcf8ab62f8) at > ../../pgsql/source/master/src/backend/commands/indexcmds.c:4117 > #8 0x00005618d72cd892 in ReindexTable (stmt=0x5618fe712228, > params=0x7ffcf8ab62f8, isTopLevel=true) > at ../../pgsql/source/master/src/backend/commands/indexcmds.c:3227 > #9 ExecReindex (pstate=pstate@entry=0x5618fe6c8c30, > stmt=stmt@entry=0x5618fe712228, isTopLevel=isTopLevel@entry=true) > at ../../pgsql/source/master/src/backend/commands/indexcmds.c:3042 > > > This is during the > REINDEX TABLE CONCURRENTLY reind_deferred; > execution. > Thanks. I will look into this. Regards, Nitin Motiani Google
