Index: openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql,v
diff -u -N -r1.15 -r1.16
--- openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql	7 Aug 2017 23:47:56 -0000	1.15
+++ openacs-4/packages/acs-kernel/sql/oracle/acs-relationships-create.sql	1 Nov 2018 08:38:00 -0000	1.16
@@ -82,7 +82,7 @@
    ''person'', ''employee'', 0, null,
    ''company'', ''employer'', 0, null)
  </pre></blockquote>
- defines an "employment" relationship type that can be expressed in
+ defines an "employment" relationship type that can be expressed
  in natural language as:
  <blockquote>
  A person may be the employee of zero or more companies, and a company
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql,v
diff -u -N -r1.41 -r1.42
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	24 Dec 2017 13:10:50 -0000	1.41
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	1 Nov 2018 08:38:00 -0000	1.42
@@ -96,16 +96,17 @@
 --           connect by prior privilege = child_privilege
 --           start with child_privilege = 'cm_perm'
 
--- This query is used to find all of the ancestor permissions of 'cm_perm'. 
--- The equivalent query for the postgresql tree-query model would be:
+-- This query is used to find all of the ancestor privileges of 'cm_perm'. 
+-- The equivalent recursive query for PostgreSQL would be:
 
--- select  h2.privilege 
---   from acs_privilege_hierarchy_index h1, 
---        acs_privilege_hierarchy_index h2
---  where h1.child_privilege = 'cm_perm'
---    and h1.tree_sortkey between h2.tree_sortkey and tree_right(h2.tree_sortkey)
---    and h2.tree_sortkey <> h1.tree_sortkey;
-
+--     with recursive privilege_path AS (
+--       select privilege, child_privilege from acs_privilege_hierarchy
+--       where child_privilege = 'cm_perm'
+--     UNION
+--       select  ph.privilege, ph.child_privilege from acs_privilege_hierarchy ph, privilege_path pp
+--       where ph.child_privilege = pp.privilege
+--     ) select * from privilege_path;
+--
 -- Also since acs_privilege_descendant_map is simply a path enumeration of
 -- acs_privilege_hierarchy, we should be able to replace the above connect-by
 -- with: 
@@ -115,7 +116,7 @@
 -- where descendant = 'cm_perm'
 
 -- This would be better, since the same query could be used for both oracle
--- and postgresql.
+-- and PostgreSQL.
 
 
 
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql,v
diff -u -N -r1.33 -r1.34
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql	7 Aug 2017 23:47:56 -0000	1.33
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql	1 Nov 2018 08:38:00 -0000	1.34
@@ -75,7 +75,7 @@
    'person', 'employee', 0, null,
    'company', 'employer', 0, null)
  </pre></blockquote>
- defines an "employment" relationship type that can be expressed in
+ defines an "employment" relationship type that can be expressed
  in natural language as:
  <blockquote>
  A person may be the employee of zero or more companies, and a company
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0a4-5.0.0a5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0a4-5.0.0a5.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0a4-5.0.0a5.sql	9 Nov 2003 12:57:10 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0a4-5.0.0a5.sql	1 Nov 2018 08:38:00 -0000	1.2
@@ -1,4 +1,4 @@
--- for postgresql 7.4 the || op needs an explicit cast.
+-- for PostgreSQL 7.4 the || op needs an explicit cast.
 
 create or replace function tree_left(varbit) returns varbit as '
 
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql	4 Oct 2010 21:59:20 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql	1 Nov 2018 08:38:00 -0000	1.2
@@ -1,4 +1,4 @@
--- Support for postgresql 9.x
+-- Support for PostgreSQL 9.x
 -- @author Victor Guerra (vguerra@gmail.com)
 
 create or replace function acs_objects_context_id_up_tr () returns trigger as '