Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mKkWR-0008Bq-Dd for pgsql-performance@arkaria.postgresql.org; Mon, 30 Aug 2021 16:52:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mKkWP-0004zi-8h for pgsql-performance@arkaria.postgresql.org; Mon, 30 Aug 2021 16:52:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mKkWO-0004za-QS for pgsql-performance@lists.postgresql.org; Mon, 30 Aug 2021 16:52:33 +0000 Received: from sonic302-21.consmr.mail.ne1.yahoo.com ([66.163.186.147]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mKkWJ-00082j-I3 for pgsql-performance@postgresql.org; Mon, 30 Aug 2021 16:52:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1630342344; bh=g5xza+ogWCI8mSZwStu/hWGNx1xVJBKK0rhOcm3uQ+k=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=bATOZcMdBzTQ6TkOciIHGKvqTR8J4sMS6aSozs9oqYaXS3QhRFsFp6SEwD6zK3LS0sOWfCGucgYeYLmTI6FBhH1/IOVeVj8ULjE83bB1dl5g4kKsia0gShRAMUDM+FPVPKuyljI/mch7SQl5nKltH7TftXwrVV4/QFRY29g68aAszHpNyWt3vS/vSGgKFEYRxr5JsiH5k703ZwN5U6K4AInrUCdQLsprUKuhzfYUPfWGCI2CirDDzRmqAmttFCHnBxphXBkt3xf4IxdVGv0ULJlqJkGD1r/MjC4HnJxZT9YU4SqNnTPxSETWom/ERYePLA9Rse2UE8krJul9pmniUw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1630342344; bh=+IVxG7vRYoYPG1ygqtq+0KcvQpqSx6dMCDIfzPahTmS=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=MZenDl1Nmpf/c6WJgB1UFzyfcmjhkBqBfa/RvVaL9F/xiyjFTxJSiMBhUw/AqZ1MJ/lE0/7Z/okwAP+KHUwhbkeacTu/CwwFYad74vrnkhBevJB6HSUwXpeELvTfb1nCwyikXZTRwyaWdKHpsUPvnqf+DmMxcjl13ji54Xh8TaeI0uZq2oLPqc04JT0MipB8R27mndhbNbY/OC3qcJT8swqKJlu9bg+Pj/ZMSf5KmYxgZMqW2w9t7uy0nD2kYC6qQoEXaXi49ANhBbmczWZhrBMZmJ+2lCoWhfuyzah4M+2oQ1S4ay1K00mBXqLoo0IcyQ8/YX6RHP31OUN7kCHgtA== X-YMail-OSG: QSyDpoYVM1kqAwMh8XwK75wUgKOJwyf5YQQ.nTgqRyNjBbiei1GKl_LCJ0RqBmo q8L7UHfhg4Mr65yg1xlwVgrWricLFrdR4AQ2CvNQ1IlPKuGcnDjXXfizyaDAf1QylkA1yWIUNC9w O.cXEgfCmUNpoVRAb4enD.TRCDHSDSkFuJLJKbVcsakz3hVdx8J3wsw7h7HIndq939FCpqUO1dON zHSE77fSJM9tYgXuGWvLobh2zBr_6AnvI_d3ImQnVKk1IGMhhOHbeZpbUC.A3kwT2pRBS8SGtmUc COsc6nL2Zp_7o0DsNnIARYq4MrM1Ul1AIXPUaKE7B8buitFpvWtOjdTyddiLiBpcUufbVPOjoizv guWrZjg7u9uABBmavfbNt2D.P5RBNcQ4WrYmhmBkai1yJN4iOBZUNMzNSukOhmrtpgv4UgNTrfSE 5gnAfev48ShEu8WXH_y.4UXrEHqlNvcZseWP87.rcUGh96bv.Zy.on.AG86GDGh68TNeS3bwUX2z xb3jc5KzKhf1N6WFUh9WMfdColmOPw0Cbau4Q91D0HJ3AOzumtC1B6Ntss3efLf03wWcboAZpltH h6fgJHp2Zf1zoJj6mNdAFIiv4umqJDypKwQ9M0vyUXjfBS1s8.PJVQ70CEB7tZG9xH7tqNG5U8vZ K81542Wi8vs.9tHVgSLxRdW38sZ.NUFfvpywpd7jDb7XppXE2d1vxIKpTS7jW6dYbwS1Vzu0rdO5 uC9JjFmVMyDCdJljdvQoWFMKBYTMFssE5UnfaOW4uhb1gNW3MCQ5Q20jYuXMkj03IH3CyvY3FPPw qy8Rt7YthiIrJ0Okyx1y1K4FKH4qfhDLKSIAeCq3dhZEMDO7ViCDdxTcC65F7iWOkfLyw9XPco4s WL6JEIfFu.nIRS7GSVbf67AKcH.FI4IkbkCc4CXRqOvlKAYttIki3ngp.0iLpuM75_9.kzZS8aCP j6rXLGcLBp0oyTWtbAcCrmviYo5yUxf7goJt0m8aSMRmWO_7GBrYErDns_OR0j4X1OYxUFBlflrH NTihmVHGJX.gwsMsgkrI5m8AmXpHvgq0PsZH0Kt3.DJGGxViyatje6Trh5cMu.Jwxux0veDjzeNp 4k0ft49HpQL.eCYWhOx.FRp8NvEtZ5fZ3xAdBL4sIb5gTONd.mXNCdu9pl7rj.ako7e7_ZEDtyCZ o732TXOHUy5VqopQJvcvPziyveEKlXyBPl_PSYqoJx389BKmYhLfC40oeKmiP0kJLCxatytxCA59 PwXoQB1KCk1js423rjB5obKBH05.8zEsffZFcH3sw.OJEAO3HUH2NInZjtxSsDwxlJ95ZyI8LldP RbTC8P.59jSylRXaEBkM6b7csyIX9uLJc20GFNcZln45mo2FtdqV3ujXJ85qnOuTv.1Z4XLtha55 0C8BmwACEnglGpVrRMzhvhXwhFtQZRqBGnNronafL4bR8Qj1GUuzZtbY9idYXtuCoorVjW2CcWAZ Mk.jpc1Q8XrewWYeUh4JVN6yyHl9.RTVdkSSd_Y5vdMoQYFsk1zt_F.YhhVYpxtnc569n2bFQKUw Pv6mTKZjGLHFTRxgsB3.6LetqWd6uoDAnuosgIrgBVuWIXNgLk98hEY7.BfBLLps2lSDFXByvE.3 WQxxJInUAjfuoMz_W37MhFnuJsb6YzUKuKPqSg6e6s_Ka9QmfBXssWqW8ewKpyWIhIWhLLjNweDz lbhogWhU02L3927C6RDljboZzzvR8I16GXUC3yUz9BErZGhIeIk6UqInrM0CIVr_Z2cVTrT_6i8v s2aLcibBK7vVek5A6d41uEOSIFMtyu1FovsddRwf85As5GmuJ2Dtw00UZ8WBtoi_gyH.s7XLTv.D Qrs0y0zg_MmRYQCt5NfyerO3zNq5as9_OccORkHn6GXZYOU2vCBlcBrsexjXcE4fnBc9ZgnsTc4l HR9fXtd45LAn69i0r4BFvjUU0LypwlkqiOCJYxK0OHduJT.SL2Nz3H7Fy9RoRnjKTouv_agp8gMW JLiQmp1e7uxkdsvUVJrZr69CJzbXCPsUo1HXkgVSE.kmq992YEM7zidoeexuJ1LLqCV5T_5MJH7E qjAOWOX2SODaBeAlpOq0y01QcZ7QF6IWIu1WEp_g2JIE6FVgHzF4ospJ0ZLRRC07xty3aFsZ5CbW W1f2xVKXq4z.4.Y24uzgALwn5gYZ4i4jr_Be7hlKz_vegfODAdhXugPQpAjWhAMu0zAjhy5bKCle .xU3zuuaJ6PUl7kYZTYLv9UaxI3jP5WdlfOsNPEM9.7I6M9fSZxEZO.CzhA8pPiFJEC_gYc_ZR9e IhIz9VKtvXMnb X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic302.consmr.mail.ne1.yahoo.com with HTTP; Mon, 30 Aug 2021 16:52:24 +0000 Date: Mon, 30 Aug 2021 16:52:21 +0000 (UTC) From: Nagaraj Raj To: "David G. Johnston" Cc: Pgsql-performance Message-ID: <1850024671.1028786.1630342341028@mail.yahoo.com> In-Reply-To: References: <2083887101.547666.1629711847197.ref@mail.yahoo.com> <2083887101.547666.1629711847197@mail.yahoo.com> Subject: Re: pg_restore schema dump to schema with different name MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1028785_207961768.1630342341026" X-Mailer: WebService/1.1.18924 YMailNorrin Content-Length: 6563 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1028785_207961768.1630342341026 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 exis= ting cluster for any test cases like sandbox schema, temp schema as live ba= ckup schema etc.=C2=A0 Thanks,Rj On Tuesday, August 24, 2021, 07:56:20 AM PDT, David G. Johnston wrote: =20 =20 On Mon, Aug 23, 2021 at 2:46 AM Nagaraj Raj wrote: Currently this is not something can do. this functionality is there in orac= le.=C2=A0 Is this future considering to add?=C2=A0 (it would really help for create a= ny test schemas without disturbing current schema. ) I find this to be not all that useful.=C2=A0 Current practice is to avoid r= elying on search_path and, in general, to schema-qualify object references = (yes, attaching a local SET search_path to a function works,=C2=A0not sure = how it would play out in this context).=C2=A0 Performing a dependency and c= ontextual 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=C2=A0say 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, tha= t for whatever reasons individuals may have no one has chosen to volunteer = or fund such development.=C2=A0 I don't even remember seeing a proposal in = the past 5 or so years. David J. =20 ------=_Part_1028785_207961768.1630342341026 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I agree with that.But, proba= bly its good idea to add this feature as many people are migrating from ora= cle to postgres. clone/restore schemas to existing cluster for any test cas= es like sandbox schema, temp schema as live backup schema etc. 
<= div dir=3D"ltr" data-setdir=3D"false">
Thanks,
Rj

=20
=20
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 he= lp for create any test schemas without disturbing current schema. )


I find this to be not a= ll that useful.  Current practice is to avoid relying on search_path a= nd, 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 i= n 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 realizatio= n, and the feature doesn't presently exist, that for whatever reasons indiv= iduals may have no one has chosen to volunteer or fund such development.&nb= sp; I don't even remember seeing a proposal in the past 5 or so years.

David J.

------=_Part_1028785_207961768.1630342341026--