Forum OpenACS Development: Re: What's the best approach to update timezone rules?

Posted by Gustaf Neumann on
Hi Cesáreo,

when the data in packages/ref-timezones/sql/common/ looks right, then see packages/ref-timezones/tcl/apm-callback-procs.tcl for how to update the database.

all the best

Hi Gustaf,

Yeah, it seems to be an upgrade problem. I'll load into database openacs/packages/ref-timezones/sql/postgresql/upgrade/upgrade-timezones.ctl

So the best approach seems to be:
1. Check rules in packages/ref-timezones/sql/common/timezones-rules.dat
2. Upgrade (vía upgrade-timezones.ctl or via apm-callback-procs.tcl)

Thanks !


I've forgot to upgrade this.

I had to upgrade it manually. It seemed to be originally an upgrade problem in my setup.

I had to do a DROP .. CASCADE (in upgrade script packages/ref-timezones/sql/postgresql/ref-timezones-drop.sql
there is no CASCADE and I had errors with events package).