Re: PROBLEM: Function does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: juleni(at)livetrade(dot)cz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PROBLEM: Function does not exist
Date: 2005-11-07 17:52:35
Message-ID: 21260.1131385955@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

juleni(at)livetrade(dot)cz writes:
> Caused by: java.sql.SQLException: ERROR: function update_bf_domain(integer, character varying,
> character varying, timestamp with time zone) does not exist

> CREATE OR REPLACE FUNCTION UPDATE_BF_DOMAIN
> (
> INTEGER,
> VARCHAR(100),
> VARCHAR(1024),
> TIMESTAMP
> ) RETURNS type_int_timestamp AS '

"timestamp" and "timestamp with time zone" are two different types ...
you probably need to declare the function using the latter.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-11-07 18:04:06 Re: PROBLEM: Function does not exist
Previous Message juleni 2005-11-07 17:00:20 PROBLEM: Function does not exist