mozilla/socorro — pull request #318 by xni (2012-02-02 18:15:30+00:00)
Title: Fixed some troubles with processors table

PostgreSQL returns local datetime as a result of now(), but checkin(self)
method uses utc_now. This causes to a very strange data in processors table:

breakpad=# select * from processors;
id | name | startdatetime | lastseendatetime
----+-----------------------+----------------------------+----------------------------
2 | laptop_7205 | 2012-02-02 21:24:43.793263 | 2012-02-02 17:49:46.547481

So, using "now() at time zone" seems to be the solution:

breakpad=# select now();
now
-------------------------------
2012-02-02 21:54:47.449261+04

breakpad=# select now() at time zone 'utc';
timezone
----------------------------
2012-02-02 17:55:02.905845

After this patch processors table looks like this:

breakpad=# select * from processors;

id | name | startdatetime | lastseendatetime
----+-----------------------+----------------------------+---------------------------
2 | laptop_9444 | 2012-02-02 18:01:48.980139 | 2012-02-02 18:01:49.03038