Forum OpenACS Development: Question regarding timezones

I'm porting the data model (the cal-table-create.sql file) of the
calendar module at the moment and I'm having a bit of trouble with
this file.
When I put this file through psql, the following error is raised:

psql:cal-table-create.sql:81: ERROR:  Relation 'timezones' does not
exist
psql:cal-table-create.sql:89: ERROR:  relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:93: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:98: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:102: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:108: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:113: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:122: ERROR:  Relation 'cal_party_prefs' does
not exist

when i removed the timezones section, the whole file works fine.

This is the part of the program raising those errors:

create table cal_party_prefs (
                      ..
                      .. -- works fine here
                      ..

        time_zone      integer
                      constraint cal_pty_prefs_time_zone_fk
                      references timezones
                      on delete cascade,

                      ..
                      .. -- works fine here
                      ..
);

comment.........;
comment.........;

will anyone be able to help?

Lilian

This package is assigned to Rafael Calvo, according to the status page.

Should it be assigned to Lilian instead?  Lilian, are you one of Rafael's students, maybe?  If not, be careful to avoid duplicating porting work already being done by others.

Thank you for your help. And yes, I'm one of Rafael's students working on the calendar package.

Can you put my name down as well, because I'm also working on the calendar package with Rafael.

Thanks