3 replies

Prisma, self relation onDelete, onUpdate behavior

I have a prisma model:

model Comment {
    ...
    children Comment[] @relation("replies")
    parent   Comment?  @relation("replies", fields: [parentId], references: [id])
    parentId String?
}

model Comment {
    ...
    children Comment[] @relation("replies")
    parent   Comment?  @relation("replies", fields: [parentId], references: [id])
    parentId String?
}

I want to add onDelete: Cascade or onUpdate: Cascade, but it returns an error:
Error validating: A self-relation must have

onDelete

onDelete

and

onUpdate

onUpdate

referential actions set to

NoAction

NoAction

in one of the @relation attributes. (Implicit default

onDelete

onDelete

SetNull

SetNull

, and

onUpdate

onUpdate

Cascade

Cascade

Prisma

Special rules for referential actions in SQL Server and MongoDB

Circular references or multiple cascade paths can cause validation errors on Microsoft SQL Server and MongoDB. Since the database does not handle these situations out of the box, learn how to solve this problem.

TTC

Theo's Typesafe Cult•3y ago•

3 replies

iboughtbed

Prisma, self relation onDelete, onUpdate behavior

I have a prisma model:

model Comment {
    ...
    children Comment[] @relation("replies")
    parent   Comment?  @relation("replies", fields: [parentId], references: [id])
    parentId String?
}

model Comment {
    ...
    children Comment[] @relation("replies")
    parent   Comment?  @relation("replies", fields: [parentId], references: [id])
    parentId String?
}

I want to add onDelete: Cascade or onUpdate: Cascade, but it returns an error:
Error validating: A self-relation must have

onDelete

onDelete

and

onUpdate

onUpdate

referential actions set to

NoAction

NoAction

in one of the @relation attributes. (Implicit default

onDelete

onDelete

SetNull

SetNull

, and

onUpdate

onUpdate

Cascade

Cascade

Prisma

Special rules for referential actions in SQL Server and MongoDB

Prisma, self relation onDelete, onUpdate behavior

Similar Threads

Prisma, self relation onDelete, onUpdate behavior

Similar Threads

Similar Threads

Similar Threads