duplicate key value violates unique constrain
Hi, I'm new to supabase and I'm developping a Flutter App.
I have manage to create table and data and query, but I'm facing an error when trying to insert a new row.
Every time I run the method to insert a new row, a get the following error:
"duplicate key value violates unique constrain".
But the thing is: I'm not passing the id column at all and it is set as unique identity not nullable. I even tried to double check and run SQL prompt to update the id column to 'GENERATED ALWAYS' as described in the docs, and commands runs without any error, but still getting the same error message to insert. Could some please advise me what I'm missing? thanks in adv
I have manage to create table and data and query, but I'm facing an error when trying to insert a new row.
Every time I run the method to insert a new row, a get the following error:
"duplicate key value violates unique constrain".
But the thing is: I'm not passing the id column at all and it is set as unique identity not nullable. I even tried to double check and run SQL prompt to update the id column to 'GENERATED ALWAYS' as described in the docs, and commands runs without any error, but still getting the same error message to insert. Could some please advise me what I'm missing? thanks in adv
