[request] Downgrade role after test fixtures loaded

[mlt]

Here is another idea... It is a known limitation that test environment has to use PostgreSQL superuser to be able to disable/enable triggers on fixtures loading.
I think it would be very nice if we could also issue set role ... to something configurable and reset role at appropriate time. This way we can test things as they are meant to be tested with normal unprivileged user.

[crashtech]

But I didn't get the idea. Why you need another role/account when inserting fixtures?
You can always define a new connection setting and ensure that is used when your fixtures are loaded.

[mlt]

Maybe I am missing something. All I know is that superuser has to be used to successfully disable referential integrity. And I want to use actual role while testing to make sure default privileges are in effects etc. How would I specify a different connection to load fixtures after all triggers are disabled?