functions get removed when migrate Prisma
Hello,
My database functions and triggers gets removed when migrate Prisma.
My database functions and triggers gets removed when migrate Prisma.
G@NanoBit
NFor more information, are your functions/triggers inside the
prisma/migrations folder?GNo my functions made using Supabase Dashboard
NOh
NIs this locally or on supabase db?
Gsupabase db
NDo you use supabase migrations or only prisma migrations?
Gyarn prisma migrate dev --name initNAh
NI recommend that you put the functions/triggers into SQL file inside a migration file:
followed by,
Then, the function will always be available when you next migration
prisma migrate dev --create-only <-- then put your function sql in the newly created file.followed by,
prisma migrate devThen, the function will always be available when you next migration
NPrisma
How to edit a migration file before applying it to avoid data loss in production.
NActually, this link is better: https://www.prisma.io/docs/guides/database/developing-with-prisma-migrate/include-unsupported-database-features
GThank you will try
