fresh regression - regproc result contains unwanted schema

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: fresh regression - regproc result contains unwanted schema
Date: 2017-10-14 13:14:27
Message-ID: CAFj8pRArVuQUxjENKxzuXZ_NhqbTTn8GhR_YsbBtbuqVvExOLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-10-14 15:26:45 Re: fresh regression - regproc result contains unwanted schema
Previous Message Michael Paquier 2017-10-14 12:33:19 Re: pg_control_recovery() return value when not in recovery