2005-12-06 09:02:10 ------------------------------------------------------------ 2005-12-06 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: initial log level is [INFO] 2005-12-06 09:02:10 [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-06 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): $Revision: 1.31 $ 2005-12-06 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): $Revision: 1.5 $ 2005-12-06 09:02:10 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): $Revision: 1.59 $ 2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): $Revision: 1.13 $ 2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): text domain is [bootstrap_gm_db_system] 2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set 2005-12-06 09:02:11 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): Giving up and falling back to NullTranslations() class in despair. 2005-12-06 09:02:11 [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-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): client encoding according to locale system: [ISO-8859-1] 2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:address@hidden): $Revision: 1.24 $ 2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:address@hidden): $Revision: 1.14 $ 2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: log level change from [INFO] to [DATA] 2005-12-06 09:02:11 [INFO] (./bootstrap_gm_db_system.py:address@hidden): startup ($Revision: 1.16 $) 2005-12-06 09:02:11 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2005-12-06 09:02:11 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2005-12-06 09:02:11 [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-06 09:02:11 [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-06 09:02:11 [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-06 09:02:11 [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-06 09:02:11 [WARN] (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user 2005-12-06 09:02:11 [WARN] (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us 2005-12-06 09:02:12 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2005-12-06 09:02:12 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2005-12-06 09:02:12 [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-06 09:02:12 [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-06 09:02:12 [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-06 09:02:12 [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-06 09:02:12 [WARN] (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user 2005-12-06 09:02:12 [WARN] (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [config] 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): if environment variable [GM_CORE_DB] exists, it override database name in config file 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping server [local host] 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): connecting to server template database 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as postgres 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected to template database [template1] 2005-12-06 09:02:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database users and groups 2005-12-06 09:02:13 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): option not found in group [user GnuMed owner] 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): User [gm-dbo] exists. 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-doctors exists. 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_medical exists. 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_office exists. 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_medical exists. 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_office exists. 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-public exists. 2005-12-06 09:02:17 [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-06 09:02:17 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:26: ERROR: role "any-doc" already exists 2005-12-06 09:02:17 [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-06 09:02:17 [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-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmPublicAccounts.sql] 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmTestAccounts.sql] 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as gm-dbo 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-06 09:02:17 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] does not exist. 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] exists. 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Successfully created GNUmed database [gnumed_v2]. 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as postgres 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping procedural languages 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installing procedural language [pg/SQL] 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql does not exist. 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql exists. 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): procedural language [pg/SQL] successfully installed 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as gm-dbo 2005-12-06 09:02:19 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevision.sql] 2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevisionViews.sql] 2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmServices.sql] 2005-12-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view v_missing_translations 2005-12-06 09:02:20 [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-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmI18N.sql] 2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit.sql] 2005-12-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_ins on audit_fields cascade 2005-12-06 09:02:20 [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-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_upd on audit_fields cascade 2005-12-06 09:02:20 [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-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_del on audit_fields cascade 2005-12-06 09:02:20 [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-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_ins on audit_trail cascade 2005-12-06 09:02:20 [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-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_upd on audit_trail cascade 2005-12-06 09:02:20 [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-06 09:02:20 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_del on audit_trail cascade 2005-12-06 09:02:20 [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-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit-dynamic.sql] 2005-12-06 09:02:20 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmNotifications-static.sql] 2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmNotifications-dynamic.sql] 2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmHousekeeping.sql] 2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [default] not installed here yet 2005-12-06 09:02:21 [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-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfig-static.sql] 2005-12-06 09:02:21 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigData.sql] 2005-12-06 09:02:21 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_options 2005-12-06 09:02:21 [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-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_numeric 2005-12-06 09:02:22 [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-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_string 2005-12-06 09:02:22 [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-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_str_array 2005-12-06 09:02:22 [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-06 09:02:22 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_data 2005-12-06 09:02:22 [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-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigViews.sql] 2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [config] (GNUmed internal name: [default]). 2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [default] resides in core database. 2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GNUmed. 2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [reference] 2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-12-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [reference] not installed here yet 2005-12-06 09:02:22 [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-06 09:02:22 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference.sql] 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference-dynamic.sql] 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference-data.sql] 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [reference] (GNUmed internal name: [reference]). 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [reference] resides in core database. 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GNUmed. 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [demographics] 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2005-12-06 09:02:23 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [personalia] not installed here yet 2005-12-06 09:02:23 [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-06 09:02:25 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics.sql] 2005-12-06 09:02:25 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics-Grants.sql] 2005-12-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_identity_dob 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_last_first 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_firstnames 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_uniq_act_name 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_uniq_active_name on names 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_uniq_active_name() 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_always_active_name on names 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function f_always_active_name() 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger TR_delete_names on identity 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function F_delete_names() 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function add_name(integer, text, text, bool) 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function set_nickname(integer, text) 2005-12-06 09:02:25 [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-06 09:02:25 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): create function set_nickname(integer, text) returns integer as ' DECLARE _id_identity alias for $1; _nick alias for $2; _names_row record; BEGIN -- 0.1: Just always set the nickname inside the active name -- post 0.1: openEHR-like (name: pk, fk_identity, name, fk_type, comment, is_legal, is_active ...) -- does name exist ? select into _names_row * from names where id_identity = _id_identity and active = true; if not found then msg = ''Cannot set nickname ['' || _nick || '']. No active row with id_identity ['' || _id_identity || ''] found.'' raise exception msg; end if; -- can directly set nickname ? -- if _names_row.preferred is null then update names set preferred = _nick where id = _names_row.id; return _names_row.id; -- end if; -- must create new row -- 1) deactivate old row ... -- update names set active = false where id = _names_row.id; -- 2) insert new row from old row and new data ... --insert into names (id_identity, active, firstnames, lastnames, preferred, comment) -- values (_id_identity, true, _names_row.firstnames, _names_row.lastnames, _nick, _names_row.comment); --if found then -- return currval(''names_id_seq''); --end if; --return NULL; END;' language 'plpgsql' 2005-12-06 09:02:25 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:165: ERROR: syntax error at or near "msg" at character 1QUERY: msg = 'Cannot set nickname [' || $1 || ']. No active row with id_identity [' || $2 || '] found.' raise exception msgCONTEXT: SQL statement in PL/PgSQL function "set_nickname" near line 12 2005-12-06 09:02:25 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): failed to import [../sql/gmDemographics-Person-views.sql] 2005-12-06 09:02:25 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot import schema definition for service [demographics] into database [core]. 2005-12-06 09:02:25 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot bootstrap services. 2005-12-06 09:02:25 [INFO] (./bootstrap_gm_db_system.py:address@hidden): shutdown