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.27 -r1.150.2.28
--- openacs-4/packages/acs-kernel/acs-kernel.info	22 Jul 2020 12:16:16 -0000	1.150.2.27
+++ openacs-4/packages/acs-kernel/acs-kernel.info	24 Mar 2021 09:51:12 -0000	1.150.2.28
@@ -9,15 +9,15 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.10.0d30" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d30.apm">
+    <version name="5.10.0d31" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d31.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2017-08-06</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">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.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.10.0d30"/>
+        <provides url="acs-kernel" version="5.10.0d31"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql,v
diff -u -r1.71.2.4 -r1.71.2.5
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	15 Nov 2019 14:43:09 -0000	1.71.2.4
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	24 Mar 2021 09:51:12 -0000	1.71.2.5
@@ -249,6 +249,14 @@
 	unique (context_id, object_id)
 );
 
+--
+-- Avoid potential loops on context_ids. A context_id must be
+-- different from the object_id. If no context_id should be checked, its
+-- value must be NULL. Note that this constraint is not guaranteed to
+-- avoid all loops; it is still possible to create indirect recursive
+-- loops but excludes some real-world problems.
+ALTER TABLE acs_objects ADD CONSTRAINT acs_objects_context_id_ck CHECK (context_id != object_id);
+
 -- The unique constraint above will force create of this index...
 -- create index acs_objects_context_object_idx onacs_objects (context_id, object_id);
 
@@ -262,6 +270,7 @@
 
 create index acs_objects_object_type_idx on acs_objects (object_type);
 
+
 CREATE OR REPLACE FUNCTION acs_objects_mod_ip_insert_tr () RETURNS trigger AS $$
 BEGIN
   new.modifying_ip := new.creation_ip;
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d30-5.10.0d31.sql'.
Fisheye: No comparison available.  Pass `N' to diff?