[Fwd: Re: [HACKERS] alternate regression dbs?]

Darn ... previously sent to wrong list

Tom Lane wrote:

>Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>
>>Currently the pg_regress script does "dbname=regression" and then does
>>everything in terms of $dbname. Would there be any value in providing a
>>--dbname=foo parameter so that different regression sets could use their
>>own db? One virtue at least might be that we would not drop the core
>>regression db all the time - having it around can be useful, I think.
>>
>>
>
>I'd be in favor of using three such DBs, one for core, PLs, and contrib.
>(More than that seems like it would clutter the disk a lot.) But I do
>use the standard regression DB as a handy testbed for a lot of stuff,
>and it has bothered me in the past that the contrib installcheck wipes
>it out.
>
>
>
>

Try attached ... season to taste. The bulk of it is changes for dblink
which has the dbname hardcoded.

There is probably more to be done with the regression stuff, but this
and the earlier change give us the low hanging fruit at least, I think.

cheers

andrew