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 > > 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
