ForeignKeyConstraintViolation on create

[blms]

Suddenly I can no longer create any new many-to-many relations. For example, creating an event I get the following error:

ConnectorError(ConnectorError { user_facing_error: None, kind: ForeignKeyConstraintViolation { constraint: Index("LocationOnEvent_B_fkey") } })

This wasn't happening as of a couple of months ago. This breaks the functionality of creating any new entries in the archive.

[blms]

It actually proceeds to create things including the M2M relations so it may just be an ignorable error that needs better handling on the frontend.

[blms]

This may be fixed with the referentialActions preview feature in Prisma.

https://github.com/prisma/prisma/releases/tag/2.26.0

It also should allow removal of raw SQL from the following:

https://github.com/mitaai/usiran-data-store/blob/master/graphql/Mutations/update.ts
https://github.com/mitaai/usiran-data-store/blob/master/graphql/Mutations/delete.ts