Tickets :: Comment on [#7429] different "datestyle" setting

* Your Email Address
* Spam protection	Enter the letters below: .___. .\ /. ..__ _/ \| >< \|\ \|\| \ ./__.\__\|/ \\| \\|\|__/
Comment	> 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.] > >
Attachment
Watch this ticket