Prisma

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``

Hey <@U01HXQN568N> :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.

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

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.

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.