Re: Feature request: temporary schemas - Mailing list pgsql-general

From Nick Guenther
Subject Re: Feature request: temporary schemas
Date
Msg-id 4de697c6-7588-41d5-8bfa-aa32a0ffa53a@email.android.com
Whole thread Raw
In response to Feature request: temporary schemas  (cowwoc <cowwoc@bbs.darktech.org>)
Responses Re: Feature request: temporary schemas  (cowwoc <cowwoc@bbs.darktech.org>)
List pgsql-general

On September 14, 2014 5:01:54 PM EDT, cowwoc <cowwoc@bbs.darktech.org> wrote:
>Hi,
>
>I'd like to propose the ability to create temporary schemas.
>
>This would facilitate running unit tests, where developers would like
>to run
>the same creation script for unit tests and production code but do not

What if you ran a temporary database instead? You can use some combination of PGHOST, PGPORT, PGUSER and PGDATABASE to
"pg_ctlstart" an empty DB and then point your unit tests at it.  Then you aren't in danger of wiping out your
productionDB either. 


pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: 2 left joins causes seqscan
Next
From: cowwoc
Date:
Subject: Re: Feature request: temporary schemas