during fresh install, we observed that db migrations could not be performed on Azure Flexible Server, because of this:
rails aborted!
ActiveRecord::StatementInvalid: PG::FeatureNotSupported: ERROR: extension "plpgsql" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL (ActiveRecord::StatementInvalid)
HINT: to learn how to allow an extension or see the list of allowed extensions, please refer to https://go.microsoft.com/fwlink/?linkid=2281561
as per https://learn.microsoft.com/en-us/answers/questions/2259086/plpgsql-not-working-on-postgres-16-8-for-flexi-ser
this extensions now enabled by default, but still seems unavailable for use
please update the migration code as described in the link above
during fresh install, we observed that db migrations could not be performed on Azure Flexible Server, because of this:
rails aborted!
ActiveRecord::StatementInvalid: PG::FeatureNotSupported: ERROR: extension "plpgsql" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL (ActiveRecord::StatementInvalid)
HINT: to learn how to allow an extension or see the list of allowed extensions, please refer to https://go.microsoft.com/fwlink/?linkid=2281561
as per https://learn.microsoft.com/en-us/answers/questions/2259086/plpgsql-not-working-on-postgres-16-8-for-flexi-ser
this extensions now enabled by default, but still seems unavailable for use
please update the migration code as described in the link above