kimb0x Comments - Answer Overflow

{
name: "PrismaClientKnownRequestError",
  code: "P2010",
  clientVersion: "5.21.1",
  meta: { code: "42501", message: "ERROR: permission denied for table User" }
}

{
name: "PrismaClientKnownRequestError",
  code: "P2010",
  clientVersion: "5.21.1",
  meta: { code: "42501", message: "ERROR: permission denied for table User" }
}

20 replies

PPrisma

•Created by kimb0x on 11/5/2024 in #help-and-questions

Can't delete records from Prisma Postgres in Studio

When I try to truncate the User table with the Prisma Client (Deno/TypeScript) I get this error:

20 replies

PPrisma

•Created by kimb0x on 11/5/2024 in #help-and-questions

Can't delete records from Prisma Postgres in Studio

Thank you again!

20 replies

PPrisma

•Created by kimb0x on 11/5/2024 in #help-and-questions

Can't delete records from Prisma Postgres in Studio

20 replies

PPrisma

•Created by kimb0x on 11/5/2024 in #help-and-questions

Can't delete records from Prisma Postgres in Studio

That inbetween table is created with this:

20 replies

PPrisma

•Created by kimb0x on 11/5/2024 in #help-and-questions

Can't delete records from Prisma Postgres in Studio

The automatically generated table _TaskToUser is the one stopping the delete command.

20 replies

PPrisma

•Created by kimb0x on 11/5/2024 in #help-and-questions

Can't delete records from Prisma Postgres in Studio

This happens with my table that has a relationship and uses an autogenerated 3rd (index) table managed by Prisma/Postgres. A simple table model with no relations allows the delete command without issues.

20 replies

PPrisma

•Created by kimb0x on 11/5/2024 in #help-and-questions

Can't delete records from Prisma Postgres in Studio

Thank you, yes, when I try to delete 1 or more records the error message is the same. I can create new records and edit the fields, though

Gaming

Programming