Are cascade deletions supported?

[alampros]

We've defined our model with onDelete: cascade on the relation, but it doesn't seem to be working when a model is deleted using the go client.

model some_table {
  id                String           @id @default(uuid())
  name              String
  some_other_table    child?  @relation(fields: [some_other_table_id], references: [id], onDelete: Cascade)
  some_other_table_id String?
}

Does prisma-client-go actually support this feature or am I doing something wrong?

Thank you!

[alampros]

It seems that deleting the associate records from some_other_table deletes the parent record, but deleting the parent doesn't delete the children. I think I've got the schema wrong.

[steebchen]

Cascading deletes are set on an SQL-level, so yes, they work with the Go client.

Can you clarify what is not working and if you are getting a specific error message, and show the schema of the other table as well?

Say you have a user with many posts. If you delete the user, all posts would be deleted as well if cascade is set, because otherwise there would be invalid foreign keys set in the posts table. However if you delete a post, it will not delete the user because there is no dependency there.