Unfortunately, I do not have the skills to improve the function. Maybe someone at dba.stackexchange.com can help me. I'll open a ticket. I hope this is okay for you.
Am 16.04.2017 22:31 schrieb Melvin Davidson:
I missed to note that this is a VIEW issue (?)
AH, IN THAT CASE, YOU ARE RIGHT. I AM RETIRED, BUT IF YOU WISH, GO AHEAD AND APPLY THE FIX YOURSELF. JUST MAKE A COMMENT AT THE TOP TO INCLUDE THE DATE, YOUR NAME AND THE FIX.
thanks for your reply. I missed to note that this is a VIEW issue (?). After duplicating a schema, views in the cloned schema (schema_new) refer still to the source schema (schema_old) in the FROM clause:
View in cloned schema (schema_new) -->
CREATE VIEW schema_new.my_view AS SELECT * FROM schema_old.my_table;
To me 'FROM schema_new.my_table' would be more logical.
Regards, Reinhard
Am 16.04.2017 22:12 schrieb Melvin Davidson: On Sun, Apr 16, 2017 at 3:20 PM, R. Reiterer <r.reiterer@posteo.at> wrote: