BUG #8168: duplicated function signature

From: vladimir(dot)jovanovic(at)aparteko(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8168: duplicated function signature
Date: 2013-05-17 10:31:04
Message-ID: E1UdHwG-00021u-VN@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8168
Logged by: Vladimir Jovanović
Email address: vladimir(dot)jovanovic(at)aparteko(dot)com
PostgreSQL version: 8.4.11
Operating system: PostgreSQL 8.4.11 on x86_64-redhat-linux-gnu, com
Description:

Hi,

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)

Actually, I created first one with intention, but the second function
appeared when I executed the following code when I wanted to replace the
function:

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$
DECLARE
BEGIN

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2013-05-17 14:11:52 Re: BUG #8168: duplicated function signature
Previous Message Boszormenyi Zoltan 2013-05-17 08:57:15 Bugfix patches in the next CF, was: Re: pg_ctl -D "/absolute/path" -m fast restart - doesn't work in some cases