SupabaseS
Supabase•4y ago
chrismasters

Cannot `supabase db push` after adding local migrations

I have created a local migration which adds a table and modifies an existing one.
After running supabase db reset everything works as expected.

The problem occurs when trying to push these changes to my production database.

I get this error when running 
supabase db push

Error: ERROR: must be owner of table streams (SQLSTATE 42501); while executing migration 20221106184147

The debug message doesn't offer much more information
2022/11/07 12:33:31 PG Recv: {"Type":"ErrorResponse","Severity":"ERROR","SeverityUnlocalized":"ERROR","Code":"42501","Message":"must be owner of table streams","Detail":"","Hint":"","Position":0,"InternalPosition":0,"InternalQuery":"","Where":"","SchemaName":"","TableName":"","ColumnName":"","DataTypeName":"","ConstraintName":"","File":"aclchk.c","Line":3583,"Routine":"aclcheck_error","UnknownFields":null}

Has anyone experienced this? Would appreciate any advice to resolve. Thanks!
Was this page helpful?