Hello,
In my function i had defined addnewuser(integer,character,......), and i call
this function by Java code.
I had created function with integer datatype but database always gives me error,
org.postgresql.util.PSQLException: ERROR: function addnewuser(bigint,character
varying,....) does not exist
Why database gives me bigint error instead i had declare integer in function.
Next i create one more function named adduser(bigint,character,....).
but then it gives me same error.
--
Thanks,
Dipesh
If you are not confident, you are doing a trial run.
Pavel Stehule wrote:
Hello
it's look like problem with casting. You defined function
name(integer,...) but you call it with bigint param. Bigint cannot be
casted to int - so you have to redefine your func - name(bigint, ...
regards
Pavel Stehule
2009/7/15 dipesh mistry (Imap) <dipesh.mis...@mobilefundas.com>:
Hello,
I have create my own function name "addnewuser(integer,varchar.....)",
and when I call this function it gives me below error,
org.postgresql.util.PSQLException: ERROR: function addnewuser(bigint,
character varying, character varying, character varying, character varying,
character varying, character varying, unknown, character varying, character
varying, character varying, character varying, character varying, character
varying, character varying, character varying, character varying, character
varying, character varying, character varying, integer) does not exist
Even though function exist why it gives me this error, we use postgres-8.3.7
latest.
We install postgres by .tar,gz file.
--
Thanks,
Dipesh
If you can't make a mistake, you can't make anything.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
