Re: [HACKERS] possibility to specify template database for pg_regress - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] possibility to specify template database for pg_regress
Date
Msg-id CAFj8pRD0Tv779DZcOAF97e=GLeKV8PH3uKKRH+V26droJpR0_Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] possibility to specify template database for pg_regress  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers


2017-02-14 3:50 GMT+01:00 Andres Freund <andres@anarazel.de>:
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.

Regards

Pavel

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] parallelize queries containing subplans
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] [Bug fix] PQsendQuery occurs error whentarget_session_attrs is set to read-write