Re: Upgrade 7.2.1 to 7.3.4 datetime Error

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: <koprahome(at)telkom(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Upgrade 7.2.1 to 7.3.4 datetime Error
Date: 2003-10-01 13:44:35
Message-ID: Pine.LNX.4.33.0310010742150.20918-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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;

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-10-01 14:17:32 Re: Upgrade 7.2.1 to 7.3.4 datetime Error
Previous Message Oliver Elphick 2003-10-01 10:46:57 Re: setting default date format