Schema/ROLE Rename Issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Schema/ROLE Rename Issue

Brajendra Pratap Singh
Hi,

Recently we had renamed schema and role but it will not get reflect in the object definitions ,plz suggest.

OLD SCHEMA/ROLE  -  TEST11
NEW SCHEMA/ROLE -  TEST

But still we are that TEST11 is present in the definition of sone objects like procudure,functions,triggers etc, so how can we modify the name from TEST11  to TEST in definition.

Thanks and Regards,
Brajendra
Reply | Threaded
Open this post in threaded view
|

Re: Schema/ROLE Rename Issue

Laurenz Albe
On Wed, 2020-09-09 at 17:04 +0530, Brajendra Pratap Singh wrote:
> Recently we had renamed schema and role but it will not get reflect in the object definitions ,plz suggest.
>
> OLD SCHEMA/ROLE  -  TEST11
> NEW SCHEMA/ROLE -  TEST
>
> But still we are that TEST11 is present in the definition of sone objects like procudure,functions,triggers etc, so how can we modify the name from TEST11  to TEST in definition.
>

You cannot habe that automatically.

While in view and index definitions as well as column default clauses,
the internal object identifier is used, so that renaming doesn't break
anything, functions are stored as string literals and parsed at
execution time.

You'll have to edit all your functions (or undo the renaming).

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



Reply | Threaded
Open this post in threaded view
|

Re: Schema/ROLE Rename Issue

Brajendra Pratap Singh
Thank you Albe..

Could u plz suggest me the best way to get the definition of functions via connecting through psql as while I am trying to change the definition through \ef function_name it won't reflect the changes.

Thanks
Brajendra

On Wed, 9 Sep, 2020, 7:39 PM Laurenz Albe, <[hidden email]> wrote:
On Wed, 2020-09-09 at 17:04 +0530, Brajendra Pratap Singh wrote:
> Recently we had renamed schema and role but it will not get reflect in the object definitions ,plz suggest.
>
> OLD SCHEMA/ROLE  -  TEST11
> NEW SCHEMA/ROLE -  TEST
>
> But still we are that TEST11 is present in the definition of sone objects like procudure,functions,triggers etc, so how can we modify the name from TEST11  to TEST in definition.
>

You cannot habe that automatically.

While in view and index definitions as well as column default clauses,
the internal object identifier is used, so that renaming doesn't break
anything, functions are stored as string literals and parsed at
execution time.

You'll have to edit all your functions (or undo the renaming).

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com