Index: openacs-4/packages/acs-subsite/tcl/subsite-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/subsite-procs-postgresql.xql,v diff -u -r1.16 -r1.17 --- openacs-4/packages/acs-subsite/tcl/subsite-procs-postgresql.xql 28 Nov 2018 17:20:48 -0000 1.16 +++ openacs-4/packages/acs-subsite/tcl/subsite-procs-postgresql.xql 3 Sep 2024 15:37:33 -0000 1.17 @@ -3,7 +3,7 @@ postgresql7.1 - + select rel_constraint__new( @@ -17,19 +17,7 @@ :user_id, :creation_ip ); - - - - - - - select t2.object_type - from acs_object_types t1, acs_object_types t2 - where t1.object_type = :object_type - and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey) - order by t2.tree_sortkey desc -