Heikki Linnakangas <hlinnakan...@vmware.com> writes: > On 17.05.2013 13:31, vladimir.jovano...@aparteko.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs