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

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

supabase db push

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

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}

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!

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

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

supabase db push

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

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}

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!

Cannot `supabase db push` after adding local migrations

Similar Threads

Cannot `supabase db push` after adding local migrations

Similar Threads

Similar Threads

Similar Threads