In the function set_db_timezone of the file date_api_sql.inc, postgres is not being detected correctly; the wrong boolean operator is being used in when checking the version of mysql so that all versions of postgres are also caught by that case.

I've attached a short patch which changes the boolean to the correct && from || and adjusts the syntax used for setting the timezone in postgres to SET TIME ZONE INTERVAL '$offset' HOURS TO MINUTES to match the postgres manual.

CommentFileSizeAuthor
date_psql.patch1.02 KBvonster

Comments

vonster’s picture

Project: Calendar » Date

Oops, wrong project.

Moving to Date API project

vonster’s picture

Component: Code » Date API
gdd’s picture

Status: Active » Reviewed & tested by the community

Patch applies with offset, does exactly what its supposed to.

karens’s picture

Status: Reviewed & tested by the community » Fixed

Fixed. Thanks!

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.