Hey all, I am getting this error when running a supabase migration:
ERROR: extension "vector" has no update path from version "0.4.0" to version "0.5.0" (SQLSTATE 22023)At statement 0: alter extension "vector" update to '0.5.0'
ERROR: extension "vector" has no update path from version "0.4.0" to version "0.5.0" (SQLSTATE 22023)At statement 0: alter extension "vector" update to '0.5.0'
After updating supabase CLI locally I had no issues running
supabase db reset
supabase db reset
with the same migrations, but when connecting and trying to push my migrations to my database i get the above error.
I've currently solved by removing the update line from the migration directly, though would love to know if there is a better way (or a manual way to make the update if thats needed).
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.