Local Development Issues
Seem to be running into intermittent issues with
ERROR: duplicate key value violates unique constraint "schema_migrations_pkey" (SQLSTATE 23505)
At statement 148:
INSERT INTO supabase_migrations.schema_migrations(version, name, statements) VALUES($1, $2, $3)
It appears the schema_migrations table gets out of sync or has broken data. the query makes sense as my last run migration is in the table. Currently spending way to long on setting this up rather than coding. My current coultions are to either rename the file or change the
Getting to a point now where i would like ot get on top of this issue now, maybe its the way i am working.
npx supabase start and npx supabase db reset. Currently im getting the error ERROR: duplicate key value violates unique constraint "schema_migrations_pkey" (SQLSTATE 23505)
At statement 148:
INSERT INTO supabase_migrations.schema_migrations(version, name, statements) VALUES($1, $2, $3)
It appears the schema_migrations table gets out of sync or has broken data. the query makes sense as my last run migration is in the table. Currently spending way to long on setting this up rather than coding. My current coultions are to either rename the file or change the
project_id in the config.toml. Getting to a point now where i would like ot get on top of this issue now, maybe its the way i am working.
