As of commit fc6d1006bda783cc002c61a5f072905849dbde4b, the regressiontests leave an unused role sitting around, because that commit removed DROP ROLE regress_test_role_super;from foreign_data.sql. Was that intentional? If so, why?
regards, tom lane