Frequent constraint failed on id when using @id @default(autoincrement())
Is there anything I should know about how
We're using postgresql.
We find that if you delete a row and then insert that same row with the same id, we hit a
Additionally, we find that if you use a transaction to insert multiple rows at once, we also hit
This is a frequent issue, so much so we have fallbacks that compute an id number, which removes the whole point of auto-increment.
@id @default(autoincrement())We're using postgresql.
We find that if you delete a row and then insert that same row with the same id, we hit a
prisma:error Unique constraint failed on the fields: ()Additionally, we find that if you use a transaction to insert multiple rows at once, we also hit
prisma:error Unique constraint failed on the fields: ()This is a frequent issue, so much so we have fallbacks that compute an id number, which removes the whole point of auto-increment.
