Re: Function does not exist

Поиск
Список
Период
Сортировка
От ANdreas Wenk
Тема Re: Function does not exist
Дата
Msg-id 4A5E2D2B.5020104@netzmeister-st-pauli.de
обсуждение исходный текст
Ответ на Function does not exist  ("dipesh mistry (Imap)" <dipesh.mistry@mobilefundas.com>)
Список pgsql-general
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, 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.
>
Hi,

I suppose you are setting the wrong parameter when calling this
function. If you use psql use the short cut command \df to get all
functions you built and check this again ... such an error message is
mostly a hint that something with the params is wrong ...

Cheers

Andy

В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: change database
Следующее
От: CG
Дата:
Сообщение: best practice transitioning from one datatype to another