Re: [GENERAL] view dependent on system view caused an upgrade to fail

2017-01-20 Thread Tom Lane
"Hu, Patricia" writes: > I have the following function and view in my db: > create or replace function ${catalogSchema}.fn_show_pg_stat_activity() > returns setof pg_catalog.pg_stat_activity as $$ select * from > pg_catalog.pg_stat_activity; $$ language sql volatile

[GENERAL] view dependent on system view caused an upgrade to fail

2017-01-20 Thread Hu, Patricia
I have the following function and view in my db: create or replace function ${catalogSchema}.fn_show_pg_stat_activity() returns setof pg_catalog.pg_stat_activity as $$ select * from pg_catalog.pg_stat_activity; $$ language sql volatile security definer; create or replace view