Search Postgresql Archives

Re: Function does not exist

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Pavel Stehule schrieb:
2009/7/16 Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx>:
Pavel Stehule schrieb:
2009/7/16 dipesh mistry (Imap) <dipesh.mistry@xxxxxxxxxxxxxxxx>:
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.
are all others parameters really varchar? You can use explicit cast to
varchar like

SELECT addnewuser(19, 'bbbb'::varchar, 'aaaaa'::varchar, ....
Pavel,

just a question. Why should it be necessary to add explicit typcasting here?
I can't see the problem in more depth. I still think that the function is
called with the wrong parameter. Would be cool to hear your points to
understand the problem better ;-)

ofcourse - explicit casting is hard method, and it's better don't use
it. But some times java environments are too smart. Explicit cast
should help with searching an problematic param.

Pavel

Thanks Pavel, then I suggest to first get the function running in psql and then check it in the Java environment ... if this has not be done allready ;-)

Cheers

Andy

Another idea to be sure that the function is working correctly is to call
the function in psql and see if an error is thrown ... if yes its a paramter
problem. If no its an external problem (I think this is called by a Java app
... isn't it?).

Cheers

Andy


regards
Pavel Stehule

--
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@xxxxxxxxxxxxxxxx>:

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux