problema con sp en postgresql

[Nighter]

saludo, disculpen tengo el siguiente codigo y me manda este error, me podrian decir cual es el problema?, de antemano gracias

SP y ejecucion:

Código:

-- Function: oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying)

-- DROP FUNCTION oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying);

CREATE OR REPLACE FUNCTION oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying)
  RETURNS void AS
$BODY$BEGIN
  INSERT INTO oots.users VALUES(nick_, pass_, name_, email_, cel_, t_user_, birth_, address_, city_);
  COMMIT;
END$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION oots."addUser"(nick_ character varying, pass_ chkpass, name_ character varying, email_ character varying, cel_ character varying, t_user_ boolean, birth_ date, address_ character varying, city_ character varying) OWNER TO nighterpgsa;

Error:

Código:

ERROR: function oots.adduser("unknown", "unknown", "unknown", "unknown", "unknown", boolean, "unknown", "unknown", "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

[Nighter]

OK ya lo resolvi, eran las comillas de oots.addUser a oots."addUser" pero ahora me manda el siguiente error:

Código:

ERROR: SPI_execute_plan failed executing query "COMMIT": SPI_ERROR_TRANSACTION
SQL state: XX000
Context: PL/pgSQL function "addUser" line 3 at SQL statement

al ejecutar:

SELECT oots."addUser"('nnick','pass','name','[email protected] ',null,TRUE,null,null,null)
alguin sabe por que y como lo puedo arreglar?

[edwinandlozano]

Iniciado por Nighter

OK ya lo resolvi, eran las comillas de oots.addUser a oots."addUser" pero ahora me manda el siguiente error:

Código:

ERROR: SPI_execute_plan failed executing query "COMMIT": SPI_ERROR_TRANSACTION
SQL state: XX000
Context: PL/pgSQL function "addUser" line 3 at SQL statement

al ejecutar:

SELECT oots."addUser"('nnick','pass','name','[email protected] ',null,TRUE,null,null,null)
alguin sabe por que y como lo puedo arreglar?

Puedes colocar el codigo de la funcion?¿ sospecho que dentro de estas estas ejecutando un commit...