Failed to create and edit tables in Supabase, "Failed to create pg.columns:..."
I have failed to create or edit tables in Supabase. It is showing an error message "Failed to create pg.columns: must be the owner of event trigger pgsodium_trg_mask_update". I think it has something to do with the launch of supabase vault, but I don't have the vault feature on my settings dashboard for now.
I am using supabase's free tier.
I have tried deleting the vault and pgsodium triggers since these are new but still failed to create the tables. I have even failed to remove the pgsodium extension. I am looking for a way to create the secret keys or disable this feature and have supabase working as before and I should be able to create tables.
I have not found a solution yet for the table editor but I am using the SQL editor. The tables can be created and edited successfully from there.
- Error : relation "OutboxState" does not exist
- copying 3 columns from a 4 column table with multiple CONFLICT conditions
- Select only distinct values from two tables on pgadmin without getting all combinations
- Using pg_notify in PostgreSQL trigger function
- postgres: using previous row value when current row value is null
- EF Core one-to-one relation returns one-to-many relation
- Efficiently storing data that is partially columnar into a DuckDB database in a purely columnar form
- Storing and managing Forex trading tick data
- Possible bug with PHP PDO and with PostgreSQL
- Error while loading shared libraries: libpq.so.5
- Duckdb sql and postgres results differ when using unnest
- How to connect to localhost with postgres_fdw?
- Python 3.10.6 alembic postgresql password with special character
- Using SQLAlchemy sessions with flask & concurrency problems
- How to reload PostgreSQL configuration
- How to show tables in PostgreSQL?
- How can I change a PostgreSQL user password?
- postgres- plsql function to get rows counts for specific columns with null data
- SQLAlchemy - Get query results in same order as IN clause
- Performance loss introducing lateral join in Postgres query
- Strange sorting behavior with bigint column via GiST index in PostgreSQL
- Laravel and PHP8.3 can't connect to Postgre database
- PgSql Insert multiple records with multiple regexp_split_to_table
- Extract weekday, millisecond, microsecond, nanosecond from a date in Postgres
- How can I refer to a variable in postgresql dynamic SQL?
- Doctrine database create command failing with Postgresql
- An exception has been raised that is likely due to a transient failure - connect local PostgreSQL to Docker container
- How to fix SQL for AWS Athena
- PHP and pgbouncer in transaction mode: current transaction is aborted
- Postgres inside Docker container, how to log JSON to Loki via Promtail?