when I fixed old bug of plpgsql_check I found new regression of regproc output.
set check_function_bodies TO off;
postgres=# create or replace function f1() returns int as $$ begin end $$ language plpgsql; CREATE FUNCTION postgres=# select 'f1()'::regprocedure::oid::regproc; regproc --------- f1 (1 row)
postgres=# create or replace function f1(int) returns int as $$ begin end $$ language plpgsql; CREATE FUNCTION postgres=# select 'f1()'::regprocedure::oid::regproc; regproc ----------- public.f1 (1 row)
When function is overwritten, then regproc result contains schema, although it is on search_path
This behave breaks regress tests (and it is not consistent)
