Re: Set timezone error

[Michael Granger]

On Tuesday, July 17, 2012 3:08:53 PM UTC-7, Liir wrote:

Can someone help me with this?

rake db:migrate

 rake aborted! 

PG::Error: ERROR: invalid value for parameter "TimeZone": "UTC" : SET time zone 'UTC'

I've tried

SET time zone 'UTC' 

which fails

I'm using Rails 3.2, PG 0.14.0, Postgresql 9.0.5 which came bundled with OSX 10.7 Lion

This is a totally new app, with the database and user created.

I don't think you need the quotes:

$ psql test

psql (9.0.5, server 9.1.2)

WARNING: psql version 9.0, server version 9.1.

         Some psql features might not work.

Type "help" for help.

test=> set time zone utc;

SET

test=> show time zone;

 TimeZone 

----------

 UTC

(1 row)

test=> 

This isn't particular to the 'pg' gem, it's just the syntax the server itself understands. 

[Liir]

Oh thank you! That worked.