2005-12-07 08:04:44 ------------------------------------------------------------ 2005-12-07 08:04:44 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: initial log level is [INFO] 2005-12-07 08:04:44 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): instantiated log file /home/richard/gnumed/gnumed/server/bootstrap/redo-v2.log with ID /home/richard/gnumed/gnumed/server/bootstrap/redo-v2.log 2005-12-07 08:04:44 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): $Revision: 1.31 $ 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): $Revision: 1.5 $ 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): $Revision: 1.59 $ 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): $Revision: 1.13 $ 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): text domain is [bootstrap_gm_db_system] 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set 2005-12-07 08:04:45 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): Giving up and falling back to NullTranslations() class in despair. 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): PostgreSQL via DB-API module "": API level 2.0, thread safety 1, parameter style "pyformat" 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): client encoding according to locale system: [ISO-8859-1] 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:address@hidden): $Revision: 1.24 $ 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:address@hidden): $Revision: 1.14 $ 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: log level change from [INFO] to [DATA] 2005-12-07 08:04:45 [INFO] (./bootstrap_gm_db_system.py:address@hidden): startup ($Revision: 1.18 $) 2005-12-07 08:04:45 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2005-12-07 08:04:45 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf'] 2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf] 2005-12-07 08:04:45 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf] 2005-12-07 08:04:45 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping GNUmed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf,v $] ($Revision: 1.4 $) 2005-12-07 08:04:45 [WARN] (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user 2005-12-07 08:04:45 [WARN] (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us 2005-12-07 08:04:46 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2005-12-07 08:04:46 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2005-12-07 08:04:46 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): config file search order: ['/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf'] 2005-12-07 08:04:46 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf] 2005-12-07 08:04:46 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf] 2005-12-07 08:04:46 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping GNUmed database system from file [$Source: /cvsroot/gnumed/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf,v $] ($Revision: 1.42 $) 2005-12-07 08:04:46 [WARN] (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user 2005-12-07 08:04:46 [WARN] (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [config] 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): if environment variable [GM_CORE_DB] exists, it override database name in config file 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping server [local host] 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): connecting to server template database 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as postgres 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected to template database [template1] 2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database users and groups 2005-12-07 08:04:48 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): option not found in group [user GnuMed owner] 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): User [gm-dbo] exists. 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-doctors exists. 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_medical exists. 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_office exists. 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_medical exists. 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_office exists. 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-public exists. 2005-12-07 08:04:51 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): CREATE USER "any-doc" WITH PASSWORD 'any-doc' IN GROUP "gm-doctors", "gm-public" 2005-12-07 08:04:51 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:26: ERROR: role "any-doc" already exists 2005-12-07 08:04:51 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): INSERT INTO gm_schema_revision (filename, version) VALUES('$RCSfile: gmPublicAccounts.sql,v $', '$Revision: 1.7 $') 2005-12-07 08:04:51 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:30: ERROR: relation "gm_schema_revision" does not exist 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmPublicAccounts.sql] 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmTestAccounts.sql] 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as gm-dbo 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] does not exist. 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] exists. 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Successfully created GNUmed database [gnumed_v2]. 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as postgres 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping procedural languages 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installing procedural language [pg/SQL] 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql does not exist. 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql exists. 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): procedural language [pg/SQL] successfully installed 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as gm-dbo 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevision.sql] 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevisionViews.sql] 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmServices.sql] 2005-12-07 08:04:54 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_missing_translations 2005-12-07 08:04:54 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmI18N.sql:223: ERROR: view "v_missing_translations" does not exist 2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmI18N.sql] 2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit.sql] 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_ins on audit_fields cascade 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:94: ERROR: rule "audit_fields_no_ins" for relation "audit_fields" does not exist 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_upd on audit_fields cascade 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:95: ERROR: rule "audit_fields_no_upd" for relation "audit_fields" does not exist 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_del on audit_fields cascade 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:96: ERROR: rule "audit_fields_no_del" for relation "audit_fields" does not exist 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_ins on audit_trail cascade 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:117: ERROR: rule "audit_trail_no_ins" for relation "audit_trail" does not exist 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_upd on audit_trail cascade 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:118: ERROR: rule "audit_trail_no_upd" for relation "audit_trail" does not exist 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_del on audit_trail cascade 2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:119: ERROR: rule "audit_trail_no_del" for relation "audit_trail" does not exist 2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit-dynamic.sql] 2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmNotifications-static.sql] 2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmNotifications-dynamic.sql] 2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmHousekeeping.sql] 2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [default] not installed here yet 2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 20051006 (prerelease)] - this is fine with me 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfig-static.sql] 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigData.sql] 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_options 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:118: ERROR: view "v_cfg_options" does not exist 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_numeric 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:141: ERROR: view "v_cfg_opts_numeric" does not exist 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_string 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:167: ERROR: view "v_cfg_opts_string" does not exist 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_str_array 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:193: ERROR: view "v_cfg_opts_str_array" does not exist 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_data 2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:219: ERROR: view "v_cfg_opts_data" does not exist 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigViews.sql] 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [config] (GNUmed internal name: [default]). 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [default] resides in core database. 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GNUmed. 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [reference] 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [reference] not installed here yet 2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 20051006 (prerelease)] - this is fine with me 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference.sql] 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference-dynamic.sql] 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference-data.sql] 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [reference] (GNUmed internal name: [reference]). 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [reference] resides in core database. 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GNUmed. 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [demographics] 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [personalia] not installed here yet 2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 20051006 (prerelease)] - this is fine with me 2005-12-07 08:04:59 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics.sql] 2005-12-07 08:04:59 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Grants.sql] 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_identity_dob 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:11: ERROR: index "idx_identity_dob" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_last_first 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:12: ERROR: index "idx_names_last_first" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_firstnames 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:13: ERROR: index "idx_names_firstnames" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_uniq_act_name 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:27: ERROR: index "idx_uniq_act_name" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_uniq_active_name on names 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:36: ERROR: trigger "tr_uniq_active_name" for table "names" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_uniq_active_name() 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:37: ERROR: function f_uniq_active_name() does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_always_active_name on names 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:39: ERROR: trigger "tr_always_active_name" for table "names" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_always_active_name() 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:40: ERROR: function f_always_active_name() does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger TR_delete_names on identity 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:82: ERROR: trigger "tr_delete_names" for table "identity" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function F_delete_names() 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:83: ERROR: function f_delete_names() does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_name(integer, text, text, bool) 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:101: ERROR: function add_name(integer, text, text, boolean) does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function set_nickname(integer, text) 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:132: ERROR: function set_nickname(integer, text) does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function create_occupation(text) 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:182: ERROR: function create_occupation(text) does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function link_person_comm(integer, text, text, bool) 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:200: ERROR: function link_person_comm(integer, text, text, boolean) does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function new_pupic() cascade 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:238: ERROR: function new_pupic() does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function new_pupic() 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:239: ERROR: function new_pupic() does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_gender_labels 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:251: ERROR: view "v_gender_labels" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_basic_person cascade 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:269: ERROR: view "v_basic_person" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_basic_person 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:270: ERROR: view "v_basic_person" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_staff 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:338: ERROR: view "v_staff" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view lnk_person2address 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:367: ERROR: view "lnk_person2address" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view lnk_org2address 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:368: ERROR: view "lnk_org2address" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_person_comms_flat cascade 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:381: ERROR: view "v_person_comms_flat" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_person_comms_flat 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:382: ERROR: view "v_person_comms_flat" does not exist 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_lnk_pers2rel 2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:415: ERROR: index "idx_lnk_pers2rel" does not exist 2005-12-07 08:05:00 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Person-views.sql] 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-data.sql:14: starting transaction 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-data.sql:30: transaction committed 2005-12-07 08:05:00 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Person-data.sql] 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_basic_address 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:52: ERROR: view "v_basic_address" does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): DROP FUNCTION create_urb(text, text, text, text) 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:87: ERROR: function create_urb(text, text, text, text) does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): DROP FUNCTION create_street(text, text, text, text, text) 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:128: ERROR: function create_street(text, text, text, text, text) does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): DROP FUNCTION create_address(text, text, text, text, text, text) 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:167: ERROR: function create_address(text, text, text, text, text, text) does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2street cascade 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:209: ERROR: view "v_zip2street" does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2street 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:210: ERROR: view "v_zip2street" does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2urb 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:243: ERROR: view "v_zip2urb" does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_uniq_zipped_urbs 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:271: ERROR: view "v_uniq_zipped_urbs" does not exist 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_zip2data 2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-GIS-views.sql:313: ERROR: view "v_zip2data" does not exist 2005-12-07 08:05:00 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-GIS-views.sql] 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-GIS-data.sql] 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Org-views.sql] 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [demographics] (GNUmed internal name: [personalia]). 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [personalia] resides in core database. 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GNUmed. 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [clinical] 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [historica] not installed here yet 2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installed PostgreSQL version: [PostgreSQL 8.1.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 20051006 (prerelease)] - this is fine with me 2005-12-07 08:05:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmclinical.sql] 2005-12-07 08:05:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmWaitingList.sql] 2005-12-07 08:05:14 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmMeasurements.sql] 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_cri_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:505: ERROR: index "idx_cri_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_cri_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:506: ERROR: index "idx_cri_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_clnarr_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:508: ERROR: index "idx_clnarr_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_clnarr_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:509: ERROR: index "idx_clnarr_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_clanote_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:511: ERROR: index "idx_clanote_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_clanote_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:512: ERROR: index "idx_clanote_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_vacc_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:514: ERROR: index "idx_vacc_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_vacc_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:515: ERROR: index "idx_vacc_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_allg_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:517: ERROR: index "idx_allg_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_allg_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:518: ERROR: index "idx_allg_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_formi_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:520: ERROR: index "idx_formi_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_formi_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:521: ERROR: index "idx_formi_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_cmeds_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:523: ERROR: index "idx_cmeds_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_cmeds_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:524: ERROR: index "idx_cmeds_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_ref_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:526: ERROR: index "idx_ref_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_ref_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:527: ERROR: index "idx_ref_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_tres_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:529: ERROR: index "idx_tres_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_tres_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:530: ERROR: index "idx_tres_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_lreq_encounter 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:532: ERROR: index "idx_lreq_encounter" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_lreq_episode 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:533: ERROR: index "idx_lreq_episode" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_narr_soap 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:569: ERROR: index "idx_narr_soap" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_narr_s 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:570: ERROR: index "idx_narr_s" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_narr_o 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:571: ERROR: index "idx_narr_o" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_narr_a 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:572: ERROR: index "idx_narr_a" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_narr_p 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:573: ERROR: index "idx_narr_p" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_clin_medication 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:586: ERROR: index "idx_clin_medication" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_episode_issue 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:595: ERROR: index "idx_episode_issue" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_episode_valid_issue 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:596: ERROR: index "idx_episode_valid_issue" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_uniq_open_epi_per_issue 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:602: ERROR: index "idx_uniq_open_epi_per_issue" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function trf_announce_episode_mod() cascade 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:608: ERROR: function trf_announce_episode_mod() does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view clin.v_pat_episodes cascade 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:651: ERROR: view "v_pat_episodes" does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function clin.f_announce_clin_item_mod() cascade 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:696: ERROR: function clin.f_announce_clin_item_mod() does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function clin.f_protect_clin_root_item() cascade 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:732: ERROR: function clin.f_protect_clin_root_item() does not exist 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view clin.v_test_type_unified cascade 2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:785: ERROR: view "v_test_type_unified" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function clin.f_announce_h_issue_mod() cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1059: ERROR: function clin.f_announce_h_issue_mod() does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view clin.v_vacc_regimes cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1129: ERROR: view "v_vacc_regimes" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view clin.v_vacc_defs4reg cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1155: ERROR: view "v_vacc_defs4reg" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_coded_terms 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1396: ERROR: index "idx_coded_terms" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_coded_term(text, text, text) cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1397: ERROR: function add_coded_term(text, text, text) does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_pat_per_encounter 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1474: ERROR: index "idx_pat_per_encounter" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_encounter_started 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1475: ERROR: index "idx_encounter_started" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_encounter_affirmed 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1476: ERROR: index "idx_encounter_affirmed" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_set_encounter_timezone() cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1485: ERROR: function f_set_encounter_timezone() does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view clin.v_pat_encounters cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1508: ERROR: view "v_pat_encounters" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view clin.v_most_recent_encounters cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1533: ERROR: view "v_most_recent_encounters" does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_rfi_type2item() cascade 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1605: ERROR: function f_rfi_type2item() does not exist 2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): create view clin.v_hx_family as select vpi.pk_patient as pk_patient, vpi.pk_health_issue as pk_health_issue, chxf.clin_when as clin_when, chxf.modified_when as modified_when, chxf.modified_by as modified_by, chxf.fk_encounter as pk_encounter, chxf.fk_episode as pk_episode, chxf.narrative as relationship, chxf.soap_cat as soap_cat, chxf.pk as pk_clin_hx_family, chxf.fk_hx_family_item as pk_hx_family_item, null::integer as pk_narrative_condition, null::integer as pk_relative_identity, hxfi.name_relative as name_relative, hxfi.dob_relative as dob_relative, hxfi.condition as condition, hxfi.age_noted as age_noted, hxfi.age_of_death as age_of_death, hxfi.is_cause_of_death as is_cause_of_death from clin.v_pat_items vpi, clin.clin_hx_family chxf, clin.hx_family_item hxfi, v_basic_person vbp where vpi.pk_item = chxf.pk_item and hxfi.pk = chxf.fk_hx_family_item and hxfi.fk_narrative_condition is null and hxfi.fk_relative is null UNION select vpi.pk_patient as pk_patient, vpi.pk_health_issue as pk_health_issue, chxf.clin_when as clin_when, chxf.modified_when as modified_when, chxf.modified_by as modified_by, chxf.fk_encounter as pk_encounter, chxf.fk_episode as pk_episode, chxf.narrative as relationship, chxf.soap_cat as soap_cat, chxf.pk as pk_clin_hx_family, chxf.fk_hx_family_item as pk_hx_family_item, null::integer as pk_narrative_condition, hxfi.fk_relative as pk_relative_identity, vbp.firstnames || ' ' || vbp.lastnames as name_relative, vbp.dob as dob_relative, hxfi.condition as condition, hxfi.age_noted as age_noted, hxfi.age_of_death as age_of_death, hxfi.is_cause_of_death as is_cause_of_death from clin.v_pat_items vpi, clin.clin_hx_family chxf, clin.hx_family_item hxfi, v_basic_person vbp where vpi.pk_item = chxf.pk_item and hxfi.pk = chxf.fk_hx_family_item and hxfi.fk_narrative_condition is null and hxfi.fk_relative = v_basic_person.pk_identity UNION select vpn.pk_patient as pk_patient, vpn.pk_health_issue as pk_health_issue, chxf.clin_when as clin_when, chxf.modified_when as modified_when, chxf.modified_by as modified_by, chxf.fk_encounter as pk_encounter, chxf.fk_episode as pk_episode, chxf.narrative as relationship, chxf.soap_cat as soap_cat, chxf.pk as pk_clin_hx_family, chxf.fk_hx_family_item as pk_hx_family_item, hxfi.fk_narrative_condition as pk_narrative_condition, vpn.pk_patient as pk_relative_identity, vbp.firstnames || ' ' || vbp.lastnames as name_relative, vbp.dob as dob_relative, vpn.narrative as condition, hxfi.age_noted as age_noted, hxfi.age_of_death as age_of_death, hxfi.is_cause_of_death as is_cause_of_death from clin.clin_hx_family chxf, clin.hx_family_item hxfi, v_basic_person vbp, clin.v_pat_narrative vpn where hxfi.pk = chxf.fk_hx_family_item and hxfi.fk_narrative_condition = vpn.pk_narrative and hxfi.fk_relative is null and vbp.pk_identity = vpn.pk_patient 2005-12-07 08:05:16 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmClinicalViews.sql:1844: ERROR: missing FROM-clause entry in subquery for table "v_basic_person" 2005-12-07 08:05:16 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): failed to import [../sql/gmClinicalViews.sql] 2005-12-07 08:05:16 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot import schema definition for service [clinical] into database [core]. 2005-12-07 08:05:16 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot bootstrap services. 2005-12-07 08:05:16 [INFO] (./bootstrap_gm_db_system.py:address@hidden): shutdown