Re: Function does not exist

[Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx>]

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