"query" operation failed
so i tried to set up a postgresql prisma 7 db with better auth schema and then when i run npx prisma studio and i try to load verification table i get this error:
"query" operation failed
with "count" as (select cast(coalesce(count(*), 0) as text) as "value" from "public"."verification" where true) select "value", "identifier", "id", "updatedAt", "createdAt", "expiresAt", "count"."value" as "ps_count" from "public"."verification", "count" where true limit $1 offset 0
this is my verification model:
model Verification {
id String @id
identifier String
value String
expiresAt DateTime
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([identifier])
@@map("verification")
}
does anyone know how to fix it?
"query" operation failed
with "count" as (select cast(coalesce(count(*), 0) as text) as "value" from "public"."verification" where true) select "value", "identifier", "id", "updatedAt", "createdAt", "expiresAt", "count"."value" as "ps_count" from "public"."verification", "count" where true limit $1 offset 0
this is my verification model:
model Verification {
id String @id
identifier String
value String
expiresAt DateTime
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([identifier])
@@map("verification")
}
does anyone know how to fix it?
