Structure with value list calls role "postgres"

[cymed]

Describe the bug The plain sql "tww_dev_structure_with_value_lists.sql" calls role "postgres" multiple times, i,e,

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA tww_app GRANT ALL ON SEQUENCES TO tww_user;

Some hosted database instances have no access to the role "postgres" (i.e. Azure)

Expected behavior no mentioning postgres

[ponceta]

What is the db_owner user in Azure?

[ponceta]

The database user postgres is a standard for all Linux server on the database installation. It has usually an only-local access priviledge.

[cymed]

"In Azure Postgres , we can't CREATE SUPERUSERS . Since this is a Managed Service , Only Microsoft is part of SUPERUSERS Group

The Azure Database for PostgreSQL server is created with 3 default roles defined azure_pg_admin azure_superuser your server admin user " taken from https://learn.microsoft.com/en-us/answers/questions/120659/create-superuser-in-paas-offering-of-azure-databas