2006-01-11 10:22:57 ------------------------------------------------------------ 2006-01-11 10:22:57 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: initial log level is [INFO] 2006-01-11 10:22:57 [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 2006-01-11 10:22:57 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): $Revision: 1.35 $ 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): $Revision: 1.5 $ 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): $Revision: 1.61 $ 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): $Revision: 1.13 $ 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): text domain is [bootstrap_gm_db_system] 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set 2006-01-11 10:22:58 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:address@hidden): Giving up and falling back to NullTranslations() class in despair. 2006-01-11 10:22:58 [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" 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:address@hidden): client encoding according to locale system: [ISO-8859-1] 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:address@hidden): $Revision: 1.25 $ 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:address@hidden): $Revision: 1.14 $ 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:address@hidden): SECURITY: log level change from [INFO] to [DATA] 2006-01-11 10:22:58 [INFO] (./bootstrap_gm_db_system.py:address@hidden): startup ($Revision: 1.20 $) 2006-01-11 10:22:58 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2006-01-11 10:22:58 [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'] 2006-01-11 10:22:58 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf] 2006-01-11 10:22:58 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-local_first.conf] 2006-01-11 10:22:58 [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.5 $) 2006-01-11 10:22:58 [INFO] (./bootstrap_gm_db_system.py:address@hidden): running as user [root] 2006-01-11 10:22:58 [INFO] (./bootstrap_gm_db_system.py:address@hidden): switching to UNIX user [postgres] 2006-01-11 10:23:01 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): (, ) 2006-01-11 10:23:01 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): ignoring command line per cfg_IGNORE_CMD_LINE 2006-01-11 10:23:01 [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'] 2006-01-11 10:23:01 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): found config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf] 2006-01-11 10:23:01 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): parsing config file [/home/richard/gnumed/gnumed/server/bootstrap/bootstrap-monolithic_core.conf] 2006-01-11 10:23:01 [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.47 $) 2006-01-11 10:23:01 [INFO] (./bootstrap_gm_db_system.py:address@hidden): running as user [postgres] 2006-01-11 10:23:01 [WARN] (./bootstrap_gm_db_system.py:address@hidden): not running as root, cannot become postmaster demon user 2006-01-11 10:23:01 [WARN] (./bootstrap_gm_db_system.py:address@hidden): may have trouble connecting as gm-dbo if IDENT auth is forced upon us 2006-01-11 10:23:02 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [config] 2006-01-11 10:23:02 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2006-01-11 10:23:02 [INFO] (./bootstrap_gm_db_system.py:address@hidden): if environment variable [GM_CORE_DB] exists, it override database name in config file 2006-01-11 10:23:02 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping server [local host] 2006-01-11 10:23:02 [INFO] (./bootstrap_gm_db_system.py:address@hidden): connecting to server template database 2006-01-11 10:23:02 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as postgres 2006-01-11 10:23:03 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2006-01-11 10:23:03 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected to template database [template1] 2006-01-11 10:23:03 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database users and groups 2006-01-11 10:23:03 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:address@hidden): option not found in group [user GnuMed owner] 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): User [gm-dbo] exists. 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-doctors exists. 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_medical exists. 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-staff_office exists. 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_medical exists. 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-trainees_office exists. 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Group gm-public exists. 2006-01-11 10:23:04 [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" 2006-01-11 10:23:04 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:26: ERROR: role "any-doc" already exists 2006-01-11 10:23:04 [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 $') 2006-01-11 10:23:04 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmPublicAccounts.sql:30: ERROR: relation "gm_schema_revision" does not exist 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmPublicAccounts.sql] 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmTestAccounts.sql] 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to template1 on localhost as gm-dbo 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2006-01-11 10:23:04 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] does not exist. 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Database [gnumed_v2] exists. 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Successfully created GNUmed database [gnumed_v2]. 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as postgres 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping procedural languages 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): installing procedural language [pg/SQL] 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql does not exist. 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Language plpgsql exists. 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): procedural language [pg/SQL] successfully installed 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): trying DB connection to gnumed_v2 on localhost as gm-dbo 2006-01-11 10:23:06 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully connected 2006-01-11 10:23:07 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevision.sql] 2006-01-11 10:23:07 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmSchemaRevisionViews.sql] 2006-01-11 10:23:07 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmServices.sql] 2006-01-11 10:23:07 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmI18N.sql] 2006-01-11 10:23:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_orig 2006-01-11 10:23:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmI18N-dynamic.sql:35: ERROR: index "idx_orig" does not exist 2006-01-11 10:23:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view i18n.v_missing_translations 2006-01-11 10:23:07 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmI18N-dynamic.sql:226: ERROR: view "v_missing_translations" does not exist 2006-01-11 10:23:07 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmI18N-dynamic.sql] 2006-01-11 10:23:07 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit.sql] 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_ins on audit.audit_fields cascade 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:105: ERROR: rule "audit_fields_no_ins" for relation "audit_fields" does not exist 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_upd on audit.audit_fields cascade 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:106: ERROR: rule "audit_fields_no_upd" for relation "audit_fields" does not exist 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_fields_no_del on audit.audit_fields cascade 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:107: ERROR: rule "audit_fields_no_del" for relation "audit_fields" does not exist 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_ins on audit.audit_trail cascade 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:128: ERROR: rule "audit_trail_no_ins" for relation "audit_trail" does not exist 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_upd on audit.audit_trail cascade 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:129: ERROR: rule "audit_trail_no_upd" for relation "audit_trail" does not exist 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop rule audit_trail_no_del on audit.audit_trail cascade 2006-01-11 10:23:08 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmAudit-dynamic.sql:130: ERROR: rule "audit_trail_no_del" for relation "audit_trail" does not exist 2006-01-11 10:23:08 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmAudit-dynamic.sql] 2006-01-11 10:23:08 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmNotifications-static.sql] 2006-01-11 10:23:08 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmNotifications-dynamic.sql] 2006-01-11 10:23:08 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmHousekeeping.sql] 2006-01-11 10:23:08 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [default] not installed here yet 2006-01-11 10:23:08 [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 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfig-static.sql] 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigData.sql] 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_options 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:126: ERROR: view "v_cfg_options" does not exist 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_numeric 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:149: ERROR: view "v_cfg_opts_numeric" does not exist 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_string 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:175: ERROR: view "v_cfg_opts_string" does not exist 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_str_array 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:201: ERROR: view "v_cfg_opts_str_array" does not exist 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop view cfg.v_cfg_opts_data 2006-01-11 10:23:09 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmConfigViews.sql:227: ERROR: view "v_cfg_opts_data" does not exist 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmConfigViews.sql] 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [config] (GNUmed internal name: [default]). 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [default] resides in core database. 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GNUmed. 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [reference] 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2006-01-11 10:23:09 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [reference] not installed here yet 2006-01-11 10:23:09 [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 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference.sql] 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference-dynamic.sql] 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmReference-data.sql] 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Registering service [reference] (GNUmed internal name: [reference]). 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): Service [reference] resides in core database. 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): It will be automatically recognized by GNUmed. 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping service [demographics] 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): bootstrapping database [core] 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): database [core] already bootstrapped 2006-01-11 10:23:10 [INFO] (./bootstrap_gm_db_system.py:address@hidden): service [personalia] not installed here yet 2006-01-11 10:23:10 [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 2006-01-11 10:23:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmDemographics.sql] 2006-01-11 10:23:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): successfully imported [../sql/gmProviderInbox-static.sql] 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_identity_dob 2006-01-11 10:23:13 [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 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_last_first 2006-01-11 10:23:13 [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 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_names_firstnames 2006-01-11 10:23:13 [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 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop index idx_uniq_act_name 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:26: ERROR: index "idx_uniq_act_name" does not exist 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_uniq_active_name on dem.names 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:35: ERROR: trigger "tr_uniq_active_name" for table "names" does not exist 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function dem.f_uniq_active_name() 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:36: ERROR: function dem.f_uniq_active_name() does not exist 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger tr_always_active_name on dem.names 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:38: ERROR: trigger "tr_always_active_name" for table "names" does not exist 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function dem.f_always_active_name() 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:39: ERROR: function dem.f_always_active_name() does not exist 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop trigger TR_delete_names on dem.identity 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:81: ERROR: trigger "tr_delete_names" for table "identity" does not exist 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): drop function dem.F_delete_names() 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:82: ERROR: function dem.f_delete_names() does not exist 2006-01-11 10:23:13 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): create or replace function dem.set_nickname(integer, text) returns integer as ' DECLARE _id_identity alias for $1; _nick alias for $2; _names_row record; msg text; 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 dem.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 dem.names set preferred = _nick where id = _names_row.id; return _names_row.id; -- end if; -- must create new row -- 1) deactivate old row ... -- update dem.names set active = false where id = _names_row.id; -- 2) insert new row from old row and new data ... --insert into dem.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' 2006-01-11 10:23:13 [ERROR] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:address@hidden): ../sql/gmDemographics-Person-views.sql:159: ERROR: syntax error at or near "raise" at character 112QUERY: SELECT 'Cannot set nickname [' || $1 || ']. No active row with id_identity [' || $2 || '] found.' raise exception $3 CONTEXT: SQL statement in PL/PgSQL function "set_nickname" near line 13 2006-01-11 10:23:13 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): failed to import [../sql/gmDemographics-Person-views.sql] 2006-01-11 10:23:13 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot import schema definition for service [demographics] into database [core]. 2006-01-11 10:23:13 [ERROR] (./bootstrap_gm_db_system.py:address@hidden): Cannot bootstrap services. 2006-01-11 10:23:13 [INFO] (./bootstrap_gm_db_system.py:address@hidden): shutdown