Hi I am getting a conflicting message after runnin...
# orm-helpb
Brothak
02/10/2022, 8:23 AMHi I am getting a conflicting message after running prisma migrate dev on existing production database:
Copy code
[*] Changed the `addresses` table
[-] Removed foreign key on columns (entity_id)
[+] Added foreign key on columns (entity_id)
[*] Changed the `entity_metadata` table
[-] Removed foreign key on columns (tag_id)
[+] Added foreign key on columns (tag_id)j
Joël
02/10/2022, 8:27 AM
It’s saying that I removed and added same foreign key on the same column?Are you using SQLite maybe?
Joël
02/10/2022, 8:29 AM
WHat’s the content of the migration file?
b
Brothak
02/10/2022, 8:39 AM@Jonas No it’s postgres, could the reason be that name of foreign keys is different?
👍 1
j
Joël
02/10/2022, 8:40 AM
It would help if you could share your migration file I think here
b
Brothak
02/10/2022, 8:43 AMFor privacy reasons I would rather not
👍 1
Brothak
02/10/2022, 8:44 AMthe migration containts creation of the tables. What I did was -> I had existing development DB run prisma db pull to create a schema. Then run https://github.com/prisma/prisma/issues/11555#issuecomment-1027242342 , because I was getting a drift detected error
Brothak
02/10/2022, 8:45 AMthis worked nicely on my local db and I wanted to do the same on production which is almost identical except seems like name for foreign keys
Brothak
02/10/2022, 8:45 AMI’ve changed names of foreing keys in prisma scheme and migration file to see if that helps, but it didnt
j
Joël
02/10/2022, 8:48 AM
Could you share the migration file in private message? (or part of it maybe?)
Did you upgrade the Prisma version recently maybe?
b
Brothak
02/10/2022, 9:08 AM@Joël send a PM
3 Views