Postgres Pro
Downloads
Home   >   mailing lists

Re: Function that exists doesn't exist? - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Function that exists doesn't exist?
Date
Msg-id 8556.1139676934@sss.pgh.pa.us
Whole thread Raw
In response to Function that exists doesn't exist?  ("Rob Johnston" <rob@aqq.com.au>)
List pgsql-jdbc
Tree view 
"Rob Johnston" <rob@aqq.com.au> writes:
> org.postgresql.util.PSQLException: ERROR: function =
> update_payable_account(integer, character varying, character varying, =
> character varying, integer, numeric, integer) does not exist

> Our function looks like this:
> CREATE OR REPLACE FUNCTION update_payable_account(id int4, name =
> "varchar", sup bpchar, cus bpchar, terms int2, del "numeric", astat =
> int4)

int2 is not integer, and bpchar is not varchar.  There is an implicit
cast from varchar to bpchar, but not from int4 to int2.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: "Rob Johnston"
Date:
Subject: Function that exists doesn't exist?
Next
From: Roman Chervotkin
Date:
Subject: PostgreSQL 8.1 and Sun Java Studio Creator2