Re: BUG #8168: duplicated function signature

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: vladimir(dot)jovanovic(at)aparteko(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8168: duplicated function signature
Date: 2013-05-17 14:11:52
Message-ID: 51963AA8.5040701@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?

- Heikki

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2013-05-17 14:24:46 Re: Bugfix patches in the next CF, was: Re: pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases
Previous Message vladimir.jovanovic 2013-05-17 10:31:04 BUG #8168: duplicated function signature