Thread: Schema/ROLE Rename Issue
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
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, <laurenz.albe@cybertec.at> 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