I keep running into this problem when I try to do ...
# orm-help
e
I keep running into this problem when I try to do
prisma migrate dev
Copy code
Migration `20220609015525_test` failed to apply cleanly to the shadow database.
Error:
db error: ERROR: type "citext" does not exist
1
j
You need to add
Copy code
CREATE EXTENSION IF NOT EXISTS citext;
one your migration files
e
Where should this to?
Copy code
CREATE EXTENSION IF NOT EXISTS citext;
j
on you migration file
then run prisma resolve with apply command
e
`The migration
20220609015525_test
is already recorded as applied in the database.`
thats what I got
Ok so I just tried running
Copy code
npx prisma migrate dev
and everything seems to be working fine
not sure what changed
j
it applied to create citext extension
does it work now?
e
the citext extension was already applied
Prior to the error* but yes it works now
j
Happy to hear that
e
Thanks for the help!
1
prisma rainbow 2
🙌 1