Stored procs / functions - execution failure

[Damian Georgiou <bchlist@xxxxxxxxx>]

Title: Stored procs / functions - execution failure

Hi All,

I am having an issue with a function where it used to run in a previous installation of postgres under windows. The box has since been decommissioned so I am unable to check exactly what version it was though it was version 8 under winxp.

I am now running postgres 8.2.5 Under OSX 10.5.3

Now I have imported the data, the function is available in the list however I get this error when I try to run it





ERROR:  function sp_schedulefromdate("unknown") does not exist
LINE 1: select sp_scheduleFromDate('2008-01-01');
               ^
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

********** Error **********

ERROR: function sp_schedulefromdate("unknown") does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You may need to add explicit type casts.
Character: 8






The function code is as below

-- Function: "sp_scheduleFromDate"(date)

-- DROP FUNCTION "sp_scheduleFromDate"(date);

CREATE OR REPLACE FUNCTION "sp_scheduleFromDate"(date)
  RETURNS refcursor AS
$BODY$declare
    v_date alias for $1;

    v_rs cursor for select
            v.sitename,
           ...
        from v_schedule v        
        where v.scheduledate = v_date::text;
begin
    open v_rs;
    return v_rs;
end;




         $BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION "sp_scheduleFromDate"(date) OWNER TO postgres;
GRANT EXECUTE ON FUNCTION "sp_scheduleFromDate"(date) TO public;
GRANT EXECUTE ON FUNCTION "sp_scheduleFromDate"(date) TO postgres;
GRANT EXECUTE ON FUNCTION "sp_scheduleFromDate"(date) TO divequee_dmpro;

Any thoughts?

Damian