Re: Function does not exist

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.mistry@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.