Hi, I'm currently getting my local environment set up with supabase and when I try to run
supabase db remote commit
supabase db remote commit
I'm getting the error
Error: Error running pg_dump on remote database: pg_dump: warning: there are circular foreign-key constraints on this table:pg_dump: hypertablepg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.pg_dump: warning: there are circular foreign-key constraints on this table:pg_dump: chunkpg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.
Error: Error running pg_dump on remote database: pg_dump: warning: there are circular foreign-key constraints on this table:pg_dump: hypertablepg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.pg_dump: warning: there are circular foreign-key constraints on this table:pg_dump: chunkpg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.
Relevant system information: OS: archlinux 64bit kernel 5.1.15 PostgreSQL version (output of postgres --version): postgres (PostgreSQL) 11.2 TimescaleDB version (output of \dx in psql): 1.5.1 Insta...
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.