From: Nagaraj Raj <nagaraj.sf@yahoo.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: pg_restore schema dump to schema with different name
Date: Mon, 30 Aug 2021 16:52:21 +0000 (UTC)
Message-ID: <1850024671.1028786.1630342341028@mail.yahoo.com> (raw)
In-Reply-To: <CAKFQuwbZnf=h0q_jafnYwmF_kv03a=k4jx9x0FucMhQOqk5XJA@mail.gmail.com>
References: <2083887101.547666.1629711847197.ref@mail.yahoo.com>
<2083887101.547666.1629711847197@mail.yahoo.com>
<CAKFQuwbZnf=h0q_jafnYwmF_kv03a=k4jx9x0FucMhQOqk5XJA@mail.gmail.com>
I agree with that.But, probably its good idea to add this feature as many people are migrating from oracle to postgres. clone/restore schemas to existing cluster for any test cases like sandbox schema, temp schema as live backup schema etc.
Thanks,Rj
On Tuesday, August 24, 2021, 07:56:20 AM PDT, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Aug 23, 2021 at 2:46 AM Nagaraj Raj <nagaraj.sf@yahoo.com> wrote:
Currently this is not something can do. this functionality is there in oracle.
Is this future considering to add? (it would really help for create any test schemas without disturbing current schema. )
I find this to be not all that useful. Current practice is to avoid relying on search_path and, in general, to schema-qualify object references (yes, attaching a local SET search_path to a function works, not sure how it would play out in this context). Performing a dependency and contextual rename of one schema name to another is challenging given all of that, and impossible if the schema name is hard-coded into a function body.
I won't say we wouldn't accept such a patch, but as this isn't exactly a new problem or realization, and the feature doesn't presently exist, that for whatever reasons individuals may have no one has chosen to volunteer or fund such development. I don't even remember seeing a proposal in the past 5 or so years.
David J.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nagaraj.sf@yahoo.com, david.g.johnston@gmail.com
Subject: Re: pg_restore schema dump to schema with different name
In-Reply-To: <1850024671.1028786.1630342341028@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox