18 replies

I messed up my supabase and drizzle setup

To start off, databases and ORMs I am not super familiar with and didn't realize I was just directly running migrations against the production db

so after chatting with some folks I decided to install docker and run

pnpm supabase start

pnpm supabase start

locally and that ended up failing due to

ERROR: column "class_year" cannot be cast automatically to type integer (SQLSTATE 42804)
At statement 1: --> statement-breakpoint                                                
ALTER TABLE "transfer_portal_entries" ALTER COLUMN "class_year" SET DATA TYPE integer

ERROR: column "class_year" cannot be cast automatically to type integer (SQLSTATE 42804)
At statement 1: --> statement-breakpoint                                                
ALTER TABLE "transfer_portal_entries" ALTER COLUMN "class_year" SET DATA TYPE integer

I used to have a

class_year

class_year

column in that table, however, I no longer do as it was renamed and even shows up under https://github.com/JamesSingleton/redshirt-sports/tree/feature/transfer-portal/supabase as being renamed... So not entirely sure what to do from here.

GitHub

redshirt-sports/supabase at feature/transfer-portal · JamesSingleto...

Website for Redshirt Sports. Contribute to JamesSingleton/redshirt-sports development by creating an account on GitHub.

Continue the conversation

Join the Discord to ask follow-up questions and connect with the community

Drizzle Team

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

11,879 Members

Join

I messed up my supabase and drizzle setup

Continue the conversation

Drizzle Team

Similar Threads

Continue the conversation

Drizzle Team