Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrade 7.2.1 to 7.3.4 datetime Error - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Upgrade 7.2.1 to 7.3.4 datetime Error
Date
Msg-id Pine.LNX.4.33.0310010742150.20918-100000@css120.ihs.com
Whole thread Raw
In response to Upgrade 7.2.1 to 7.3.4 datetime Error  (Eko Pranoto <koprapostgres@telkom.net>)
List pgsql-admin
Tree view 
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;

pgsql-admin by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: setting default date format
Next
From: Tom Lane
Date:
Subject: Re: Upgrade 7.2.1 to 7.3.4 datetime Error