On 2017-02-14 11:46:52 +0900, Michael Paquier wrote: > > I still fail to see why --use-existing as suggested in > > https://www.postgresql.org/message-id/20170208002900.vkldujzfkwbvqqq7@alap3.anarazel.de > > isn't sufficient. > > Some tests create objects without removing them, meaning that > continuous runs would fail with only --use-existing. This patch brings > value in such cases.
You can trivially script the CREATE/DROP DB outside with --use-existing. Which seems a lot more flexible than adding more and more options to pg_regress.
Using template is natural and very simply solution - more it doesn't need any outer scripts - so infrastructure for test can be pretty simply in this case.