PostgreSql Unable to change ownership of database or tables

### Is there an existing issue for this?

- [x] I have searched the existing issues

### Describe the bug

When transitioning from Aspire v9.1 to above, instead of having a single managed identity across all services, there are now separate managed identities per service.

My application uses MartenDb to perform event sourcing. This requires the logged in user to be the owner of the tables so that can make necessary changes.

My PostgreSQL Flexible server instance already has databases and tables that were created using the old managed identity. I have been unsuccessful in finding any way to change the ownership of the objects to the new managed identity.

### Expected Behavior

When the provisioning is done, there is a special superuser account azuresu which only MS can use. I am not sure if this is used to configure the PostgreSql instance. There needs to be some mechanism by which the ownership of objects can be changed.

### Steps To Reproduce

No repro - try to change the ownership of database or table in Azure PostgreSql instance without using superuser.

### Exceptions (if any)

_No response_

### .NET Version info

_No response_

### Anything else?

_No response_