Hi
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)
Tested on master
Regards
Pavel