Re: BUG #8168: duplicated function signature

Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> writes:
> On 17.05.2013 13:31, vladimir(dot)jovanovic(at)aparteko(dot)com wrote:
>> I noticed that I have two functions with the same signature.
>>
>> sp_get_league_prediction(IN _id bigint, IN _rank integer, IN
>> _log_in_expectence double precision, IN _feathers_gained integer, IN
>> _tokens_all integer, IN _tokens_active integer, IN _score integer)
>>
>> sp_get_league_prediction(_id bigint, _rank integer, _log_in_expectence
>> double precision, _feathers_gained integer, _tokens_all integer,
>> _tokens_active integer, _score integer)

> In addition to higher-level checks, there is a unique index in the
> pg_proc catalog that should not let that happen, so to be honest, I find
> that hard to believe. Are you 100% they have the same signature? Are
> they in different schemas, perhaps? In psql, what does "\df
> sp_get_league_prediction" return?

If they are in different schemas, you'd probably need
\df *.sp_get_league_prediction
to see both.

regards, tom lane