Kyrre Gjerstad Comments - Answer Overflow

Kyrre Gjerstad

Explore posts from servers

KPCKevin Powell - Community DTDrizzle Team

•Created by Kyrre Gjerstad on 1/29/2024 in #help

Cannot drop index 'PRIMARY' - planetscale

for anyone searching for the same, this patch worked for me: https://github.com/drizzle-team/drizzle-orm/issues/1428#issuecomment-1916722940 would be great to have an official fix for this though!

4 replies

DTDrizzle Team

•Created by Kyrre Gjerstad on 1/29/2024 in #help

Cannot drop index 'PRIMARY' - planetscale

I suspect there may be an issue with how drizzle-kit and planetscale interfaces. When I run pnpm drizzle-kit push:mysql --config=drizzle.config.ts immediately after a successful push, it wants to perform the following action, even though there are no schema changes.

ALTER TABLE `petLog_usersToPets` DROP PRIMARY KEY;
ALTER TABLE `petLog_usersToPets` ADD PRIMARY KEY(`userId`,`petId`);

ALTER TABLE `petLog_usersToPets` DROP PRIMARY KEY;
ALTER TABLE `petLog_usersToPets` ADD PRIMARY KEY(`userId`,`petId`);

4 replies

Gaming

Programming