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
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 |