Getting closer, does part of clinical now.....
BTW what was the last syntax error you fixed in the sql files, can you send me
the original and the mistake.
Ricahrd
On Wednesday 07 December 2005 00:27, Karsten Hilbert wrote:
> On Tue, Dec 06, 2005 at 09:04:02AM +1100, Richard wrote:
> > ==> bootstrapping "reference" ...
> > ==> bootstrapping "demographics" ...
> > Cannot bootstrap services.
> > Please check the log file for details.
>
> This is fixed now, too.
>
> Karsten
2005-12-07 08:04:44 ------------------------------------------------------------
2005-12-07 08:04:44 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: initial log level is [INFO]
2005-12-07 08:04:44 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): $Revision: 1.31 $
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): $Revision: 1.5 $
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPG.py:[EMAIL PROTECTED]): $Revision: 1.59 $
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): $Revision: 1.13 $
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): text domain is [bootstrap_gm_db_system]
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): ${BOOTSTRAP_GM_DB_SYSTEM_DIR} not set
2005-12-07 08:04:45 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmI18N.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): PostgreSQL via DB-API module "<module 'pyPgSQL.PgSQL' from '/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.pyc'>": 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:[EMAIL PROTECTED]): client encoding according to locale system: [ISO-8859-1]
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmAuditSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.24 $
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/server/bootstrap/gmNotificationSchemaGenerator.py:[EMAIL PROTECTED]): $Revision: 1.14 $
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmLog.py:[EMAIL PROTECTED]): SECURITY: log level change from [INFO] to [DATA]
2005-12-07 08:04:45 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): startup ($Revision: 1.18 $)
2005-12-07 08:04:45 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-local_first.conf>)
2005-12-07 08:04:45 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-07 08:04:45 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-07 08:04:45 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): (<aDir=None>, <aName=bootstrap-monolithic_core.conf>)
2005-12-07 08:04:46 [INFO] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): ignoring command line per cfg_IGNORE_CMD_LINE
2005-12-07 08:04:46 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): not running as root, cannot become postmaster demon user
2005-12-07 08:04:46 [WARN] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): bootstrapping service [config]
2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): bootstrapping server [local host]
2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): connecting to server template database
2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as postgres
2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected to template database [template1]
2005-12-07 08:04:48 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database users and groups
2005-12-07 08:04:48 [WARN] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmCfg.py:[EMAIL PROTECTED]): option <password> not found in group [user GnuMed owner]
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): User [gm-dbo] exists.
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-doctors exists.
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_medical exists.
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-staff_office exists.
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_medical exists.
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-trainees_office exists.
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Group gm-public exists.
2005-12-07 08:04:51 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../sql/gmPublicAccounts.sql:30: ERROR: relation "gm_schema_revision" does not exist
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmPublicAccounts.sql]
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmTestAccounts.sql]
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to template1 on localhost as gm-dbo
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-07 08:04:51 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed_v2] does not exist.
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Database [gnumed_v2] exists.
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Successfully created GNUmed database [gnumed_v2].
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed_v2 on localhost as postgres
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping procedural languages
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): installing procedural language [pg/SQL]
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql does not exist.
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Language plpgsql exists.
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): procedural language [pg/SQL] successfully installed
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): trying DB connection to gnumed_v2 on localhost as gm-dbo
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully connected
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevision.sql]
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmSchemaRevisionViews.sql]
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmServices.sql]
2005-12-07 08:04:54 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view v_missing_translations
2005-12-07 08:04:54 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmI18N.sql:223: ERROR: view "v_missing_translations" does not exist
2005-12-07 08:04:54 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmI18N.sql]
2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmAudit.sql]
2005-12-07 08:04:55 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]): successfully imported [../sql/gmAudit-dynamic.sql]
2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmNotifications-static.sql]
2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmNotifications-dynamic.sql]
2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmHousekeeping.sql]
2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service [default] not installed here yet
2005-12-07 08:04:55 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): successfully imported [../sql/gmConfig-static.sql]
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmConfigData.sql]
2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view cfg.v_cfg_options
2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_numeric
2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_string
2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_str_array
2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view cfg.v_cfg_opts_data
2005-12-07 08:04:56 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]): successfully imported [../sql/gmConfigViews.sql]
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Registering service [config] (GNUmed internal name: [default]).
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Service [default] resides in core database.
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): It will be automatically recognized by GNUmed.
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [reference]
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database [core] already bootstrapped
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service [reference] not installed here yet
2005-12-07 08:04:56 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): successfully imported [../sql/gmReference.sql]
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmReference-dynamic.sql]
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmReference-data.sql]
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Registering service [reference] (GNUmed internal name: [reference]).
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Service [reference] resides in core database.
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): It will be automatically recognized by GNUmed.
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [demographics]
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database [core] already bootstrapped
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service [personalia] not installed here yet
2005-12-07 08:04:57 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics.sql]
2005-12-07 08:04:59 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics-Grants.sql]
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): drop index idx_identity_dob
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_names_last_first
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_names_firstnames
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_uniq_act_name
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop trigger tr_uniq_active_name on names
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function f_uniq_active_name()
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop trigger tr_always_active_name on names
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function f_always_active_name()
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop trigger TR_delete_names on identity
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function F_delete_names()
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function add_name(integer, text, text, bool)
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function set_nickname(integer, text)
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function create_occupation(text)
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function link_person_comm(integer, text, text, bool)
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function new_pupic() cascade
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function new_pupic()
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_gender_labels
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_basic_person cascade
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_basic_person
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_staff
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view lnk_person2address
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view lnk_org2address
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_person_comms_flat cascade
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_person_comms_flat
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_lnk_pers2rel
2005-12-07 08:04:59 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics-Person-views.sql]
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-data.sql:14: starting transaction
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../sql/gmDemographics-Person-data.sql:30: transaction committed
2005-12-07 08:05:00 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics-Person-data.sql]
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop view v_basic_address
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
DROP FUNCTION create_urb(text, text, text, text)
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
DROP FUNCTION create_street(text, text, text, text, text)
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_zip2street cascade
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_zip2street
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_zip2urb
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_uniq_zipped_urbs
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view v_zip2data
2005-12-07 08:05:00 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics-GIS-views.sql]
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics-GIS-data.sql]
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmDemographics-Org-views.sql]
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Registering service [demographics] (GNUmed internal name: [personalia]).
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Service [personalia] resides in core database.
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): It will be automatically recognized by GNUmed.
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping service [clinical]
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): bootstrapping database [core]
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): database [core] already bootstrapped
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): service [historica] not installed here yet
2005-12-07 08:05:11 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): 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:[EMAIL PROTECTED]): successfully imported [../sql/gmclinical.sql]
2005-12-07 08:05:13 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmWaitingList.sql]
2005-12-07 08:05:14 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): successfully imported [../sql/gmMeasurements.sql]
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]):
drop index idx_cri_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_cri_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_clnarr_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_clnarr_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_clanote_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_clanote_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_vacc_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_vacc_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_allg_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_allg_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_formi_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_formi_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_cmeds_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_cmeds_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_ref_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_ref_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_tres_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_tres_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_lreq_encounter
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_lreq_episode
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_narr_soap
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_narr_s
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_narr_o
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_narr_a
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_narr_p
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_clin_medication
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_episode_issue
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_episode_valid_issue
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_uniq_open_epi_per_issue
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function trf_announce_episode_mod() cascade
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view clin.v_pat_episodes cascade
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function clin.f_announce_clin_item_mod() cascade
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function clin.f_protect_clin_root_item() cascade
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view clin.v_test_type_unified cascade
2005-12-07 08:05:15 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function clin.f_announce_h_issue_mod() cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view clin.v_vacc_regimes cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view clin.v_vacc_defs4reg cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_coded_terms
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function add_coded_term(text, text, text) cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_pat_per_encounter
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_encounter_started
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop index idx_encounter_affirmed
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function f_set_encounter_timezone() cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view clin.v_pat_encounters cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop view clin.v_most_recent_encounters cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
drop function f_rfi_type2item() cascade
2005-12-07 08:05:16 [DATA] (/home/richard/gnumed/gnumed/Gnumed/pycommon/gmPsql.py:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]):
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:[EMAIL PROTECTED]): ../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:[EMAIL PROTECTED]): failed to import [../sql/gmClinicalViews.sql]
2005-12-07 08:05:16 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot import schema definition for service [clinical] into database [core].
2005-12-07 08:05:16 [ERROR] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): Cannot bootstrap services.
2005-12-07 08:05:16 [INFO] (./bootstrap_gm_db_system.py:[EMAIL PROTECTED]): shutdown
_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
