Re: [GENERAL] Function does not exist

2009-07-18 Thread Sim Zacks
DIPESH WROTE: > 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, > charac

Re: [GENERAL] Function does not exist

2009-07-16 Thread Andreas Wenk
Pavel Stehule schrieb: 2009/7/16 Andreas Wenk : Pavel Stehule schrieb: 2009/7/16 dipesh mistry (Imap) : 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 e

Re: [GENERAL] Function does not exist

2009-07-16 Thread Pavel Stehule
2009/7/16 Andreas Wenk : > Pavel Stehule schrieb: >> >> 2009/7/16 dipesh mistry (Imap) : >>> >>> 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 give

Re: [GENERAL] Function does not exist

2009-07-16 Thread Andreas Wenk
Pavel Stehule schrieb: 2009/7/16 dipesh mistry (Imap) : 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: fu

Re: [GENERAL] Function does not exist

2009-07-16 Thread Pavel Stehule
2009/7/16 dipesh mistry (Imap) : > 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 > add

Re: [GENERAL] Function does not exist

2009-07-16 Thread dipesh mistry (Imap)
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

Re: [GENERAL] Function does not exist

2009-07-15 Thread Pavel Stehule
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) : > Hello, > > I have create my own func

Re: [GENERAL] Function does not exist

2009-07-15 Thread ANdreas Wenk
dipesh mistry (Imap) wrote: 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, char

[GENERAL] Function does not exist

2009-07-15 Thread dipesh mistry (Imap)
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 var