Drizzle TeamDT
Drizzle Team•2y ago
BaNuni

"Duplicate Index" - but no dupliacte index...

Hey there, I've HAD a duplicate index in one of my schemas:
{ tenantId, f0, f1, f2 }) => ({
       myUniqueIdx: uniqueIndex('uniqueIdx').on(tenantId, f1, f2),
        myIdx: index('imyIdx').on(tenantId, f0, f1, f2),
        myOtherIdx: index('myIdx').on(tenantId, f0, f2, f1),
    }

which resulted in the first one overridden in the generated migration.
this code is already deployed

I added 2 columns, (e.g f3 and f4) and when I'm trying to generate migrations (pg) I'm getting
We've found duplicated index name across public schema. Please rename your index in either the myTable table or the table with the duplicated index name

Even though currently I've no duplication nowhere...
I want to fix it now, so I changed to the very very sure that's not duplicate:
{ tenantId, f0, f1, f2 }) => ({
       myUniqueIdx: uniqueIndex('aaa').on(tenantId, f1, f2),
       myIdx: index('bbb').on(tenantId, f0, f1, f2),
       myOtherIdx: index('ccc').on(tenantId, f0, f2, f1),
}

but I get the same error...
If I remove all of them completely, The generation succeeds.

Whay am I missing?
Was this page helpful?