"supabase db push" fails, generated migration contains schema "_analytics" about supabase HOT 6 CLOSED

I've fixed this regression npx supabase@beta db diff. Apologies for the inconvenience.

from supabase.

Hey hey, thanks for opening!

By default, the migrations commands exclude system schemas but it can include them if it is run with -s. Was it ever run to include the _analytics schema or is this included consistently when you run commands like db dump or db pull?

I cannot reproduce but this does not mean it is not a bug! Just want to sanity check first that _analytics was never included. You can check this in your terminal history (ctrl+r) will allow you to search.

from supabase.

I only used -s public once with supabase db dump, but this did not affect migrations created afterwards. _analytics was never included explicitly. The migration just prior to the faulty one did not contain _analytics.

Happy to share a debug log if there is a way to exclude private/organization data.

from supabase.

Hello, I have the same issue, I created a new project online, then linked it to a local projet, pulled the db. I then enabled "analytics" in config.toml then ran "db diff" to create a migration file which should not contain anything because it's a brand new project with nothing added but it does contain the definitions for the table _analytics.

from supabase.

Just upgraded my local environment to v1.167.4 (CLI); issue still exists.
When I create a new migration (e.g. supabase db diff -f add_output_tables --use-migra), the log output explicitly says that the extra schemas are included:

Diffing schemas: _analytics,_realtime,extensions,public

When I add -s public, the log will state Diffing schemas: public, but the actual migration file will still contain the extra schemas.

Update: It now worked as expected using -s public, still failing without.

from supabase.

I have the exact same issue today.
Thank @stefan-girlich for the workaround.
But internal schema should be excluded while creating migration.

from supabase.