Re: Feature request: temporary schemas

Hi Nick,

I don't think this would help for three reasons:

1. I'm already planning to run unit tests against a separate (but
identical) database than production, so there's no danger of wiping
out the production database.
2. I need to create a new temporary schema per test, and run 4-10 of
tests per second. I'm guessing this wouldn't perform well using
"pg_ctl".
3. And finally, I'd like to configure all this through JDBC (pure
Java). "pg_ctl" would require me to interact with native code.

Gili

On 14/09/2014 5:52 PM, Nick Guenther [via PostgreSQL] wrote:
>
>
> On September 14, 2014 5:01:54 PM EDT, cowwoc <[hidden email]
> </user/SendEmail.jtp?type=node&node=5819003&i=0>> 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_ctl start"
> an empty DB and then point your unit tests at it. Then you aren't in
> danger of wiping out your production DB either.
>
>
> --
> Sent via pgsql-general mailing list ([hidden email]
> </user/SendEmail.jtp?type=node&node=5819003&i=1>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
> ------------------------------------------------------------------------
> If you reply to this email, your message will be added to the
> discussion below:
> http://postgresql.1045698.n5.nabble.com/Feature-request-temporary-schemas-tp5819001p5819003.html
>
> To unsubscribe from Feature request: temporary schemas, click here
> <http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5819001&code=Y293d29jQGJicy5kYXJrdGVjaC5vcmd8NTgxOTAwMXwxNTc0MzIxMjQ3>.
> NAML
> <http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Feature-request-temporary-schemas-tp5819001p5819004.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.