| 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: | Whole Thread | Raw Message | 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 |