I was upgrading from 5.4.3 to 5.5.0 and encountered this error:
Installing data model for Reference Data - Timezone 5.5.0...
* Loading data model c:/aolserver/servers/openacs/packages/ref-timezones/sql/postgresql/ref-timezones-create.sql...
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
Failed to install Reference Data - Timezone, version 5.5.0. The following error was generated:
psql:ref-timezones-create.sql:59:
ERROR: relation "timezone_seq" already exists
psql:ref-timezones-create.sql:70: ERROR: relation "timezones" already exists
psql:ref-timezones-create.sql:80: ERROR: duplicate key violates unique constraint "arr_table_name_un" CONTEXT: SQL statement "INSERT INTO acs_reference_repositories (repository_id,table_name,internal_data_p, last_update,package_name,source, source_url,effective_date,expiry_date, maintainer_id,lob) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 )" PL/pgSQL function "acs_reference__new" line 66 at SQL statement PL/pgSQL function "acs_reference__new" line 9 at return
psql:ref-timezones-create.sql:103: ERROR: relation "timezone_rules" already exists psql:ref-timezones-create.sql:105: ERROR: relation "timezone_rules_idx1" already exists
psql:ref-timezones-create.sql:106: ERROR: relation "timezone_rules_idx2" already exists
