Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -r1.150.2.60 -r1.150.2.61 --- openacs-4/packages/acs-kernel/acs-kernel.info 5 Dec 2023 17:14:58 -0000 1.150.2.60 +++ openacs-4/packages/acs-kernel/acs-kernel.info 23 Apr 2024 12:19:02 -0000 1.150.2.61 @@ -9,15 +9,15 @@ f t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. 2023-07-10 OpenACS The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures. 3 - + Index: openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql,v diff -u -r1.9.4.1 -r1.9.4.2 --- openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql 21 Feb 2022 17:57:38 -0000 1.9.4.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/security-create.sql 23 Apr 2024 12:19:02 -0000 1.9.4.2 @@ -65,23 +65,23 @@ BEGIN LOOP -- first try to update the key - update sec_session_properties + update sec_session_properties set property_value = p_value, secure_p = p_secure_p, last_hit = p_last_hit where session_id = p_session_id and module = p_module and property_name = p_name; - IF found THEN - return; - END IF; - -- not there, so try to insert the key - -- if someone else inserts the same key concurrently, - -- we could get a unique-key failure - BEGIN - insert into sec_session_properties - (session_id, module, property_name, secure_p, last_hit) - values (p_session_id, p_module, p_name, p_secure_p, p_last_hit); - RETURN; - EXCEPTION WHEN unique_violation THEN - -- Do nothing, and loop to try the UPDATE again. - END; + IF found THEN + RETURN; + END IF; + -- not there, so try to insert the key + -- if someone else inserts the same key concurrently, + -- we could get a unique-key failure + BEGIN + insert into sec_session_properties + (session_id, module, property_name, property_value, secure_p, last_hit) + values (p_session_id, p_module, p_name, p_value, p_secure_p, p_last_hit); + RETURN; + EXCEPTION WHEN unique_violation THEN + -- Do nothing, and loop to try the UPDATE again. + END; END LOOP; END; $$ LANGUAGE plpgsql; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1b4-5.10.1b5.sql'. Fisheye: No comparison available. Pass `N' to diff?