Re: [Gnumed-devel] Concurrent connections on the same patient

[Slappinjohn]

Hi,

so which tables actually do need replication?


                              List of relations
       Schema       |                Name
--------------------+-------------------------------------
 au                 | referral
 audit              | audit_fields                        no
 audit              | audit_trail                         no
 audit              | audited_tables                      no
 audit              | log_access_log                      no
 audit              | log_active_substance                no
 audit              | log_address                         no
 audit              | log_allergy                         no
 audit              | log_allergy_state                   no
 audit              | log_beh_fall_typ                    no
 audit              | log_behandlungsfall                 no
 audit              | log_branded_drug                    no
 audit              | log_clin_aux_note                   no
 audit              | log_clin_diag                       no
 audit              | log_clin_item_type                  no
 audit              | log_clin_narrative                  no
 audit              | log_consumable_substance            no
 audit              | log_consumed_substance              no
 audit              | log_data_source                     no
 audit              | log_doc_desc                        no
 audit              | log_doc_med                         no
 audit              | log_encounter                       no
 audit              | log_episode                         no
 audit              | log_family_history                  no
 audit              | log_fhx_relation_type               no
 audit              | log_form_data                       no
 audit              | log_form_instances                  no
 audit              | log_gender_label                    no
 audit              | log_health_issue                    no
 audit              | log_hospital_stay                   no
 audit              | log_hx_family_item                  no
 audit              | log_identity                        no
 audit              | log_identity_tag                    no
 audit              | log_inbox_item_category             no
 audit              | log_inbox_item_type                 no
 audit              | log_incoming_data_unmatchable       no
 audit              | log_incoming_data_unmatched         no
 audit              | log_lab_request                     no
 audit              | log_lab_test_gnr                    no
 audit              | log_lnk_code2aoe                    no
 audit              | log_lnk_code2episode                no
 audit              | log_lnk_code2fhx                    no
 audit              | log_lnk_code2h_issue                no
 audit              | log_lnk_code2narrative              no
 audit              | log_lnk_code2procedure              no
 audit              | log_lnk_code2rfe                    no
 audit              | log_lnk_constraint2vacc_course      no
 audit              | log_lnk_identity2ext_id             no
 audit              | log_lnk_identity2primary_doc        no
 audit              | log_lnk_job2person                  no
 audit              | log_lnk_org_unit2comm               no
 audit              | log_lnk_org_unit2ext_id             no
 audit              | log_lnk_pat2vaccination_course      no
 audit              | log_lnk_person2relative             no
 audit              | log_lnk_substance2brand             no
 audit              | log_lnk_tst2norm                    no
 audit              | log_lnk_type2item                   no
 audit              | log_lnk_vaccination_course2schedule no
 audit              | log_lnk_vaccine2inds                no
 audit              | log_message_inbox                   no
 audit              | log_occupation                      no
 audit              | log_operation                       no
 audit              | log_org                             no
 audit              | log_org_unit                        no
 audit              | log_paperwork_templates             no
 audit              | log_prax_geb_paid                   no
 audit              | log_procedure                       no
 audit              | log_referral                        no
 audit              | log_relation_types                  no
 audit              | log_report_query                    no
 audit              | log_staff                           no
 audit              | log_staff_role                      no
 audit              | log_state                           no
 audit              | log_street                          no
 audit              | log_substance_in_brand              no
 audit              | log_substance_intake                no
 audit              | log_tag_image                       no
 audit              | log_test_org                        no
 audit              | log_test_result                     no
 audit              | log_test_type                       no
 audit              | log_urb                             no
 audit              | log_vacc_indication                 no
 audit              | log_vacc_route                      no
 audit              | log_vaccination                     no
 audit              | log_vaccination_course              no
 audit              | log_vaccination_course_constraint   no
 audit              | log_vaccination_definition          no
 audit              | log_vaccination_schedule            no
 audit              | log_vaccine                         no
 audit              | log_vaccine_batches                 no
 audit              | log_waiting_list                    no
 audit              | log_xlnk_identity                   no
 bill               | bill_item
 blobs              | doc_desc
 blobs              | doc_med
 blobs              | doc_obj
 blobs              | doc_type
 blobs              | lnk_doc2hospital_stay
 blobs              | lnk_doc_med2episode
 blobs              | reviewed_doc_objs
 cfg                | cfg_data
 cfg                | cfg_item
 cfg                | cfg_numeric
 cfg                | cfg_str_array
 cfg                | cfg_string
 cfg                | cfg_template
 cfg                | cfg_type_enum
 cfg                | config
 cfg                | db_logon_banner
 cfg                | report_query
 clin               | _enum_allergy_type
 clin               | active_substance
 clin               | allergy
 clin               | allergy_state
 clin               | clin_aux_note
 clin               | clin_diag
 clin               | clin_item_type
 clin               | clin_narrative
 clin               | clin_root_item
 clin               | encounter
 clin               | encounter_type
 clin               | episode
 clin               | family_history
 clin               | fhx_relation_type
 clin               | form_data
 clin               | form_instances
 clin               | health_issue
 clin               | hospital_stay
 clin               | incoming_data_unmatchable
 clin               | incoming_data_unmatched
 clin               | keyword_expansion
 clin               | lab_request
 clin               | lnk_code2aoe
 clin               | lnk_code2episode
 clin               | lnk_code2fhx
 clin               | lnk_code2h_issue
 clin               | lnk_code2item_root
 clin               | lnk_code2narrative
 clin               | lnk_code2procedure
 clin               | lnk_code2rfe
 clin               | lnk_constraint2vacc_course
 clin               | lnk_pat2vaccination_course
 clin               | lnk_substance2episode
 clin               | lnk_tst2norm
 clin               | lnk_ttype2unified_type
 clin               | lnk_type2item
 clin               | lnk_vaccination_course2schedule
 clin               | lnk_vaccine2inds
 clin               | meta_test_type
 clin               | procedure
 clin               | review_root
 clin               | reviewed_test_results
 clin               | soap_cat_ranks
 clin               | substance_intake
 clin               | test_org
 clin               | test_result
 clin               | test_type
 clin               | vacc_indication
 clin               | vacc_route
 clin               | vaccination
 clin               | vaccination_course
 clin               | vaccination_course_constraint
 clin               | vaccination_definition
 clin               | vaccination_schedule
 clin               | vaccine
 clin               | vaccine_batches
 clin               | waiting_list
 de_de              | beh_fall_typ
 de_de              | behandlungsfall
 de_de              | kvk
 de_de              | lab_test_gnr
 de_de              | payment_method
 de_de              | prax_geb_paid
 de_de              | zuzahlungsbefreiung
 dem                | address
 dem                | address_type
 dem                | country
 dem                | enum_comm_types
 dem                | enum_ext_id_types
 dem                | gender_label
 dem                | identity
 dem                | identity_tag
 dem                | inbox_item_category
 dem                | inbox_item_type
 dem                | lnk_identity2comm
 dem                | lnk_identity2ext_id
 dem                | lnk_job2person
 dem                | lnk_org_unit2comm
 dem                | lnk_org_unit2ext_id
 dem                | lnk_person2relative
 dem                | lnk_person_org_address
 dem                | marital_status
 dem                | message_inbox
 dem                | name_gender_map
 dem                | names
 dem                | occupation
 dem                | org
 dem                | org_category
 dem                | org_unit
 dem                | relation_types
 dem                | staff
 dem                | staff_role
 dem                | state
 dem                | street
 dem                | urb
 gm                 | access_log
 gm                 | notifying_tables
 gm                 | schema_revision
 i18n               | curr_lang
 i18n               | keys
 i18n               | translations
 information_schema | sql_features                        no
 information_schema | sql_implementation_info             no
 information_schema | sql_languages                       no
 information_schema | sql_packages                        no
 information_schema | sql_parts                           no
 information_schema | sql_sizing                          no
 information_schema | sql_sizing_profiles                 no
 pg_catalog         | pg_aggregate                        no
 pg_catalog         | pg_am                               no
 pg_catalog         | pg_amop                             no
 pg_catalog         | pg_amproc                           no
 pg_catalog         | pg_attrdef                          no
 pg_catalog         | pg_attribute                        no
 pg_catalog         | pg_auth_members                     no
 pg_catalog         | pg_authid                           no
 pg_catalog         | pg_cast                             no
 pg_catalog         | pg_class                            no
 pg_catalog         | pg_collation                        no
 pg_catalog         | pg_constraint                       no
 pg_catalog         | pg_conversion                       no
 pg_catalog         | pg_database                         no
 pg_catalog         | pg_db_role_setting                  no
 pg_catalog         | pg_default_acl                      no
 pg_catalog         | pg_depend                           no
 pg_catalog         | pg_description                      no
 pg_catalog         | pg_enum                             no
 pg_catalog         | pg_extension                        no
 pg_catalog         | pg_foreign_data_wrapper             no
 pg_catalog         | pg_foreign_server                   no
 pg_catalog         | pg_foreign_table                    no
 pg_catalog         | pg_index                            no
 pg_catalog         | pg_inherits                         no
 pg_catalog         | pg_language                         no
 pg_catalog         | pg_largeobject                      no
 pg_catalog         | pg_largeobject_metadata             no
 pg_catalog         | pg_namespace                        no
 pg_catalog         | pg_opclass                          no
 pg_catalog         | pg_operator                         no
 pg_catalog         | pg_opfamily                         no
 pg_catalog         | pg_pltemplate                       no
 pg_catalog         | pg_proc                             no
 pg_catalog         | pg_rewrite                          no
 pg_catalog         | pg_seclabel                         no
 pg_catalog         | pg_shdepend                         no
 pg_catalog         | pg_shdescription                    no
 pg_catalog         | pg_statistic                        no
 pg_catalog         | pg_tablespace                       no
 pg_catalog         | pg_trigger                          no
 pg_catalog         | pg_ts_config                        no
 pg_catalog         | pg_ts_config_map                    no
 pg_catalog         | pg_ts_dict                          no
 pg_catalog         | pg_ts_parser                        no
 pg_catalog         | pg_ts_template                      no
 pg_catalog         | pg_type                             no
 pg_catalog         | pg_user_mapping                     no
 public             | basic_unit
 public             | form_field_types
 public             | form_fields
 public             | form_job_queue
 public             | form_job_targets
 public             | form_print_defs
 public             | gm_client_db_match
 public             | housekeeping_todo
 public             | test_norm
 public             | unit
 ref                | atc
 ref                | atc_staging
 ref                | branded_drug
 ref                | code_thesaurus_root
 ref                | coding_system_root
 ref                | consumable_substance
 ref                | data_source
 ref                | document_type
 ref                | form_types
 ref                | icd10
 ref                | icd9
 ref                | icpc
 ref                | icpc_chapter
 ref                | icpc_component
 ref                | icpc_thesaurus
 ref                | lnk_substance2brand
 ref                | loinc
 ref                | loinc_staging
 ref                | ops
 ref                | other_code
 ref                | papersizes
 ref                | paperwork_templates
 ref                | tag_image
 staging            | lab_request                         no
 staging            | test_result                         no
(301 rows)

???

Marc