You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
If you create a new instance for one of the tables, e.g. task, in Supabase directly and enter the id manually, the client throws an error when trying to create a new instance with the same id.
Expected behavior
Drizzle or whatever, should recognize that the key exists and skip to the next available id in the sequence.
Additional Notes
Steps to reproduce:
Create a new task in the DB directly and set the task_id manually to 1.
Switch over to the client and refresh. New task should appear in the UI.
Try to create a new task from the interface.
On submit, you should see the following error: PostgresError: duplicate key value violates unique constraint "task_pkey"
The text was updated successfully, but these errors were encountered:
ricayanzon
changed the title
C(10.4): Duplicate key value violates unique constraint when setting task id from Supabase
C(10.4): Duplicate key value violates unique constraint after creating task in DB directly
Jul 13, 2024
Describe the bug
If you create a new instance for one of the tables, e.g. task, in Supabase directly and enter the id manually, the client throws an error when trying to create a new instance with the same id.
Expected behavior
Drizzle or whatever, should recognize that the key exists and skip to the next available id in the sequence.
Additional Notes
Steps to reproduce:
PostgresError: duplicate key value violates unique constraint "task_pkey"
The text was updated successfully, but these errors were encountered: