From: | "dipesh mistry (Imap)" <dipesh(dot)mistry(at)mobilefundas(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Function does not exist |
Date: | 2009-07-16 07:05:07 |
Message-ID: | 4A5ED123.5040704@mobilefundas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)mistry(at)mobilefundas(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2009-07-16 07:58:06 | Re: initdb --locale=LATIN1 fails on Windows |
Previous Message | Ms swati chande | 2009-07-16 07:02:53 | Using the GEQO |