[GENERAL] Function Issue and casting

[Juan Pablo Cook]

Hi friends, It's my first time I'm writing to the list. All days I enjoy the list!
I declare a function, and when I want to call this, it fails.

My function:
CREATE OR REPLACE FUNCTION alta_docente(integer,varchar,varchar,varchar,bigint,varchar,integer)
RETURNS VOID AS
$body$
declare
    codigo integer;
begin
    INSERT INTO persona(cod,dni,nombre,apellido,domicilio,telefono) VALUES (DEFAULT,$1,$2,$3,$4,$5);
    codigo := currval('persona_cod_seq');

        INSERT INTO persona_docente(cod,legajo,antiguedad) VALUES (codigo,$6,$7);
end;
$body$
LANGUAGE 'plpgsql';

The call I'm doing:
SELECT alta_docente(2323232,cast('Mariela' AS varchar),cast('Botti' AS varchar),cast('232 de Noviemb23' AS varchar),cast(2312312321AS bigint),cast('323232A' AS varchar),23)

And here is the error:

ERROR:  function alta_docente(integer, character varying, character varying, character varying, bigint, character varying, integer) does not exist at character 8
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT:  SELECT alta_docente(2323232,cast('Mariela' AS varchar),cast('Botti' AS varchar),cast('232 de Noviemb23' AS varchar),cast(2312312321AS bigint),cast('323232A' AS varchar),23)

I don't know what's the problem, because I did all the explicit cast I think to convert types. If someone can help me, It would be great!

Thanks a lot

JP Cook

Sorry about my bad english!

[Adrian Klaver]

Is this a schema path issue? Did you create function in one schema and call it
from another which does not have access to the function schema? Two things to
check are the search path and whether the user calling the function has rights
to the schema containing the function.

--
Adrian Klaver
akl...@comcast.net

--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Juan Pablo Cook]

Adrian, thanks a lot!!! for your quicky reply. Thats the error!, my casting was ok, but my schema path was wrong. I didn't realize that.

Thanks a lot!

Bye!