Re: Function does not exist - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Function does not exist
Date
Msg-id 162867790907151258s66734865j169e45813c618d75@mail.gmail.com
Whole thread Raw
In response to Function does not exist  ("dipesh mistry (Imap)" <dipesh.mistry@mobilefundas.com>)
Responses Re: Function does not exist
List pgsql-general
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@mobilefundas.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.
>

pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: Re: initdb --locale=LATIN1 fails on Windows
Next
From: "Abraham, Danny"
Date:
Subject: Re: initdb --locale=LATIN1 fails on Windows