Re: BUG #8168: duplicated function signature

Hi Heikki,

Here you can find attached .csv semicolon separated made by :"SELECT * FROM
pg_proc WHERE proname LIKE 'sp_get_league_prediction".
"\df sp_get_league_prediction" is also attached.

Both functions are returning the same setof record:

---------------------------
CREATE OR REPLACE FUNCTION 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)
RETURNS SETOF record AS
$BODY$
...
---------------------------
CREATE OR REPLACE FUNCTION sp_get_league_prediction(_id bigint, _rank
integer, _log_in_expectence double precision, _feathers_gained integer,
_tokens_all integer, _tokens_active integer, _score integer)
RETURNS SETOF record AS
$BODY$
...

On Fri, May 17, 2013 at 4:11 PM, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com
> wrote:

> On 17.05.2013 13:31, vladimir(dot)jovanovic(at)aparteko(dot)**com<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
>

--

*Vladimir Jovanović* <http://www.aparteko.com/>

http://www.aparteko.com

CELL: +381 64 211 79 79

OFFICE: + 381 11 314 86 38

E-MAIL: vladimir(dot)jovanovic(at)aparteko(dot)com

[image: Description: cid:image001(dot)png(at)01CD3D1C(dot)7D977930]

setting standards in social gaming development