Re: error msg about stored procedures and relations not existing... - Mailing list pgsql-jdbc

From Per-Olof Norén
Subject Re: error msg about stored procedures and relations not existing...
Date
Msg-id 3EAD61B7.5020801@alma.nu
Whole thread Raw
In response to error msg about stored procedures and relations not existing...  ("Bill Thomason" <wbt@modelsoftware.com>)
List pgsql-jdbc
Bill Thomason wrote:

> Hi,
>
>
>
> I have Postgres 7.3.2 running on a Mandrake Linux 9.0 box.  I have a
> series a defined tables and two stored procedures defined in a database.
>
>
>
> I have some java code that makes a remote connection and will call the
> stored procedures and insert the returned values along with data
> through the jdbc connection.
>
>
>
> Whenever I do an insert I will get messages such as:
>
>
>
> ERROR:  Relation "image" does not exist
>
>
>
> where image is one of several tables.
>
>
>
> I get the following message concerning the stored procedures:
>
>
>
> ERROR:  Functionget_next_local_id(integer) does not exist
>
>         Unable to identify a function that satisfies the given
> argument types
>
>         You may need to add explicit typecasts
>
Something like this usually happens to me if I´m calling a procedure
with a value that is really of another datatype, eg bigint.
An example:
insert into atable (global_id, local_id)
values (1234, get_next_local_id(7832173878937128))

This might not translate into a call to get_next_local_id(integer), but
rather a call  get_next_local_id(bigint)
a typed called would look something like
get_next_local_id(3123123213123123::integer)


Just my 2 cents...
Regards,
Per-Olof


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reset query buffers
Next
From: Frédéric Liotino
Date:
Subject: max connection