From: | Per-Olof Norén <per-olof(dot)noren(at)alma(dot)nu> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Cc: | wbt(at)modelsoftware(dot)com |
Subject: | Re: error msg about stored procedures and relations not existing... |
Date: | 2003-04-28 17:15:35 |
Message-ID: | 3EAD61B7.5020801@alma.nu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeancarlo Sott | 2003-04-30 06:34:12 | Inquiry From Form [pgsql] |
Previous Message | Bill Thomason | 2003-04-28 15:33:59 | error msg about stored procedures and relations not existing... |