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
