[Tickets #7429] different "datestyle" setting - postgres

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7429
------------------------------------------------------------------------------
  Ticket             | 7429
  Created By         | renik at post.cz
  Summary            | different "datestyle" setting - postgres
  Queue              | Horde Groupware Webmail Edition
  Version            | 1.2
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


renik at post.cz (2008-10-03 11:10) wrote:

Hi,
I have problem with creating tables in postgres through the use of setup.php


_doQuery: [Error message: Could not execute statement]
[Last executed query: CREATE  TABLE horde_alarms (alarm_id  
VARCHAR(255) DEFAULT ' ' NOT NULL, alarm_uid VARCHAR(255) DEFAULT  
NULL, alarm_start
TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00' NOT NULL,  
alarm_end TIMESTAMP without time zone DEFAULT '0000-00-00 00:00:00',  
alarm_methods VARCHAR(255) DEFAULT NULL, alarm_params TEXT,  
alarm_title VARCHAR(255) DEFAULT ' ' NOT NULL, alarm_text TEXT,  
alarm_snooze TIMESTAMP without time zone DEFAULT '0000-00-00  
00:00:00', alarm_dismissed SMALLINT DEFAULT 0 NOT NULL, alarm_internal  
TEXT)]
[Native message: ERROR:  date/time field value out of range:  
"0000-00-00 00:00:00"
HINT:  Perhaps you need a different "datestyle" setting.]