Any way to ignore constraints when running a table truncate

Question

Any way to ignore constraints when running a table truncate via `executeRaw` in my seed file `Raw query failed Code `0A000` Message `db error ERROR cannot truncate a table referenced in a foreign key constraint``

Ryan · Answer

Hey < Christian Strang> wave There s an option to set the variable ``SET FOREIGN KEY CHECKS = 0 ` to disable checks before performing a truncate but I haven t tried this

Christian Strang · Answer

Thank you I ll see if I can get it working and post my final query if it does

Christian Strang · Answer

As I m using postgresql the `SET FOREIGN KEY CHECKS = 0` is not an option I tried it with the postgres equivalent but it also failed For now its just easier to reset the db as a whole in development but would be nice if someone found a way to truncate tables while ignoring constraints

Ryan · Answer

I think this should work after the following <https github com prisma prisma issues 4303|request> is supported but I think resetting and creating the tables again before seeding would be the recommended approach for now