upgrading from 7.1.2 to 7.3.2

From: patrick <patrick+pgsql(at)boxsoft(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: upgrading from 7.1.2 to 7.3.2
Date: 2003-03-05 01:39:42
Message-ID: 20030304173942.Z4392@3eye.boxsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greetings,

I've just upgraded from PostgreSQL 7.1.2 to 7.3.2. Things seem to
work OK so far (only been about 70 min or so since upgrade).

One thing I did see break is how I've been using timestamp():

e.g.,

in 7.1.2
=> select timestamp ( 1046923200 );
timestamp
------------------------
2003-03-05 20:00:00-08
(1 row)

in 7.3.2
=> select timestamp ( 1046923200 );
ERROR: TIMESTAMP(1046923200) precision must be between 0 and 6

Can anyone point me to a work-around?

Thanks in advance,

sidster
--
They who would sacrifice freedom for security will have neither.
-Ben Franklin

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-03-05 07:47:24 Re: sort / limit / range problem
Previous Message Tom Lane 2003-03-04 22:33:20 Re: Forcing query to use an index