| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Paolo Saudin <paolosaudin(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SELECT to_timestamp crash PostgreSQL 9.1beta1 |
| Date: | 2011-06-02 02:32:12 |
| Message-ID: | 4DE6F62C.1020604@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 06/02/2011 03:15 AM, Paolo Saudin wrote:
> Trying to convert unix time to date time format, I encountered a database
> crash.
This is a known issue, and will be addressed in the next beta. Detail
from an earlier post by Tom Lane:
Tom Lane wrote:
> This is the known problem with timezone abbreviations not being
> initialized correctly on Windows --- anything involving interpreting a
> "keyword" in datetime input will go belly up. See commits 2e82d0b39,
> e05b86644.
>
> regards, tom lane
Those commits have a more detailed explanation, and can be found here:
but the short version appears to be "Fixed in the next version".
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clemens Schwaighofer | 2011-06-02 06:35:55 | DBD::PG and long running queries and tcp stack timeout |
| Previous Message | Merlin Moncure | 2011-06-02 01:56:04 | Re: Table with active and historical data |