The problem is with date_trunc, and I'm (obviously) not running 7.1. Here's the output from a different system (at work, not at home) that's likewise running 7.0.x:
openacs=# select date_trunc('Month'::varchar, '2001-04-01'::date);
date_trunc
------------------------
2001-03-01 00:00:00-08
(1 row)
Would the easiest solution be, presumably, to upgrade to 7.1? If so, how stable is it, and how much work (dump/restore, for example) is required for the upgrade?
