https://supabase.com/ logo
Following managing environments docs immediately results in failed migrations
f

francis

05/25/2023, 9:02 PM
The docs in question: https://supabase.com/docs/guides/cli/managing-environments Running
supabase db remote commit
immediately generates a migration which cannot be applied (EDIT: to an instance started via the supabase cli) and fails. The offending line is:
CREATE EXTENSION IF NOT EXISTS "supabase_vault" WITH SCHEMA "vault";
This fails in the type generation CI with:
Error: ERROR: extension "supabase_vault" is not available (SQLSTATE 0A000)
.
Note: I confirmed this behavior with a newly created project, with no database changes made. The migration generated from a new supabase project causes this error. This is preventing any integration tests from running since they require a supabase instance to run against, which cannot start due to this migration failure.
Found a related issue, it appears that docs are out of date: https://github.com/supabase/supabase/issues/14056