This is strange because the id column is an Int and should be default autoincrementing. The error message complains about int4. If I look in the database the only int4 column is the id field. Answer It seems your users are too active, if there is more than 2.147.483.647 comment ids, the Int id has reach it max value You
Tag: prisma
Prisma PostgreSQL queryRaw error code 42P01 table does not exist
I am trying to run a query that searches items in the Item table by how similar their title and description are to a value, the query is the following: However when the code is run I receive the following error: I have run also the following query: Which correctly shows that the Item table exists! Where is the error?
Prisma update with relation in WHERE property
Given these schemas: How would I create a prisma SQL update for the awayinfo table if the only identifier I have would be the Name of a player and not the ID? what I tried: I try to pass something into the WHERE part as seen below: but it always gives me the Error: I got pretty desperate and even
How to do SQL insert for Postgres using Prisma with condition on count of rows?
I am trying to insert a row into database provided that – number of rows satisfying some condition already in the table is less than certain threshold, say 10. For example, in below model, I don’t want to have a project to have more than 10 users; so count(projectId) should be less than 10: In general SQL world, I would