Example code from docs for adding indices doesn't work

I'm using the example code from https://orm.drizzle.team/docs/indexes-constraints#indexes (screenshot #1)

To create an index, but the generated migration and SQL don't have any corresponding index creation code (screenshot #2)

I generate the migration using

npx drizzle-kit generate:pg --schema db/schema/schema.ts --out db/migrations

npx drizzle-kit generate:pg --schema db/schema/schema.ts --out db/migrations

npx drizzle-kit generate:pg --schema db/schema/schema.ts --out db/migrations

npx drizzle-kit generate:pg --schema db/schema/schema.ts --out db/migrations

Screen_Shot_2024-01-18_at_12.00.04_AM.png

Screen_Shot_2024-01-18_at_12.00.09_AM.png

Drizzle ORM - next gen TypeScript ORM

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

jackpuOP•1/29/24, 6:54 AM

The problem was that auto-completion in VSCode imported indexindex /uniqueIndexuniqueIndex methods from mysql-coremysql-core instead of pg-corepg-core

Example code from docs for adding indices doesn't work

Similar Threads

Similar Threads

Similar Threads