<bug>: trying to remove enterprise sickbay ward

[AC = any-doc]

Report sent via GNUmed's handler for unexpected exceptions.

user comment  : trying to remove enterprise sickbay ward

client version: 1.8.9

system account: aimee
staff member  : Aimee Carroll (AC = any-doc)
sender email  : <supply email address for getting feedback on bug report>

 # enable Launchpad bug tracking
 affects gnumed
 tag automatic-report
 importance medium

Exception:

 type: <class 'psycopg2.errors.ForeignKeyViolation'>
 value: update or delete on table "org_unit" violates foreign key constraint 
"fk_clin_ext_care_fk_org_unit" on table "external_care"
DETAIL:  Key (pk)=(2) is still referenced from table "external_care".


Traceback:

  File "/usr/share/gnumed/Gnumed/wxpython/gmListWidgets.py", line 820, in 
_on_remove_button_pressed
    self.__do_delete()
  File "/usr/share/gnumed/Gnumed/wxpython/gmListWidgets.py", line 718, in 
__do_delete
    if not 
self.__delete_callback(self._LCTRL_items.get_selected_item_data(only_one = 
True)):
  File "/usr/share/gnumed/Gnumed/wxpython/gmOrganizationWidgets.py", line 208, 
in _del
    return gmOrganization.delete_org_unit(unit = item['pk_org_unit'])
  File "/usr/share/gnumed/Gnumed/business/gmOrganization.py", line 463, in 
delete_org_unit
    rows, idx = gmPG2.run_rw_queries(queries = [{'cmd': cmd, 'args': args}], 
get_col_idx = False)
  File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 1888, in 
run_rw_queries
    curs.execute(query['cmd'], args)
  File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 146, in execute
    return super().execute(query, vars)

gnumed-2023_03_04-17_14_10-9886.log
Description: Text document