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?