exception - cannot change/save comment in demographics

[Maria Scappini]

Hello!

I had an exception when trying to save comment in demographics tab -> 
identity -> comment.

Cannot save the edited/added comment when the patient/person has more 
than one alias already registered.

If person only has one alias, comment can be changed/added no problem. 
If i add an alias and then try to edit or add a comment, then the 
exception occurs again.

Log file attached.


type: <class 'psycopg2.errors.TooManyRows'>
value: query returned more than one row
HINT:  Make sure the query returns a single row, or use LIMIT 1.
CONTEXT:  PL/pgSQL function dem.assert_unique_named_identity() line 10 
at SQL statement

  File 
"/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/wxpython/gmDemographicsWidgets.py", 
line 1487, in _on_save_identity_details_button_pressed
    if not self._PNL_identity.save():
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File 
"/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/wxpython/gmEditArea.py", 
line 237, in save
    return self._save_as_update()
           ^^^^^^^^^^^^^^^^^^^^^^
  File 
"/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/wxpython/gmDemographicsWidgets.py", 
line 1032, in _save_as_update
    self.data.save()
  File 
"/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/pycommon/gmBusinessDBObject.py", 
line 693, in save
    return self.save_payload(conn = conn)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File 
"/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/pycommon/gmBusinessDBObject.py", 
line 761, in save_payload
    conn.commit()

gnumed-2025_03_10-13_12_41-14658.log
Description: Text Data