Thread: Upgrade 7.2.1 to 7.3.4 datetime Error

Hey folks..
I have problem when upgrade from 7.2.1 to 7.3.4
with function I create...

How I can fix it ?

Thank you for any suggestion
EKo Pranoto


--------------Message Recieve----------------------
ERROR:  Function datetime(timestamp with time zone) does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts

-----------------FUNCTION------start-------------
CREATE FUNCTION "set_waktu" ()
RETURNS timestamp without time zone AS 'set datestyle to ''european'';
set datestyle to ''sql'';
select datetime(now()) as result' LANGUAGE 'sql';
---------------FUNCTION--------end-------------

On Wed, 1 Oct 2003, Eko Pranoto wrote:

> Hey folks..
> I have problem when upgrade from 7.2.1 to 7.3.4
> with function I create...
>
> How I can fix it ?

add this to template1 on the 7.3.4 database before importing into it:

create domain datetime as timestamptz;

Eko Pranoto <koprapostgres@telkom.net> writes:
> select datetime(now()) as result' LANGUAGE 'sql';

"datetime" isn't a standard type name anymore.  Use "timestamp".

            regards, tom lane