PostgresDatabaseMigrator Wrong Order

[Ogrvat]

Contact Details

[email protected]

Version

8.x (develop, pre-release), 8.x

On which operating system(s) are you experiencing the issue?

Linux

Using which broker(s) did you encounter the issue?

No response

What are the steps required to reproduce the issue?

Wrong SQL scripts order in PostgresDatabaseMigrator:
https://github.com/MassTransit/MassTransit/blob/4fe74cde9368b910f39f990edb0bfbbc605bccaf/src/Transports/MassTransit.SqlTransport.PostgreSql/SqlTransport/PostgreSql/PostgresDatabaseMigrator.cs#L22-L23

Current:
ALTER SCHEMA "{1}" OWNER TO "{0}";
GRANT "{0}" TO "{2}";

Expected:
GRANT "{0}" TO "{2}";
ALTER SCHEMA "{1}" OWNER TO "{0}";

Can't change owner without grant.

What is the expected behavior?

.

What actually happened?

.

Related log output, including any exceptions

No response

Link to repository that demonstrates/reproduces the issue

No response

[phatboyg]

You'd need to provide a specific scenario where this fails because it works everywhere I've tried it.

Note that you should not be using the same username as the admin username.