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.18 -r1.150.2.19
--- openacs-4/packages/acs-kernel/acs-kernel.info	19 Aug 2019 14:23:03 -0000	1.150.2.18
+++ openacs-4/packages/acs-kernel/acs-kernel.info	3 Sep 2019 09:09:16 -0000	1.150.2.19
@@ -9,15 +9,15 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.10.0d21" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d21.apm">
+    <version name="5.10.0d22" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.0d22.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.0d21"/>
+        <provides url="acs-kernel" version="5.10.0d22"/>
 
         <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.2 -r1.71.2.3
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	14 Aug 2019 07:31:43 -0000	1.71.2.2
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	3 Sep 2019 09:09:16 -0000	1.71.2.3
@@ -529,6 +529,19 @@
 -- ACS_OBJECT PACKAGE --
 ------------------------
 
+--
+-- Create an SQL schema to allow the same dot notation as in
+-- Oracle. The advantage of this notation is that the function can be
+-- called identically for PostgreSQL and Oracle, so much duplicated
+-- code can be removed.
+--
+--
+-- TODO: handling of schema names in define_function_args, port all
+-- acs_object api to the dot notation.
+--
+CREATE SCHEMA acs_object;
+
+
 select define_function_args('acs_object__initialize_attributes','object_id');
 
 
@@ -868,15 +881,10 @@
 $$ LANGUAGE plpgsql;
 
 
--- function name
-select define_function_args('acs_object__name','object_id');
-
-
-
 --
 -- procedure acs_object__name/1
 --
-CREATE OR REPLACE FUNCTION acs_object__name(
+CREATE OR REPLACE FUNCTION acs_object.name(
    name__object_id integer
 ) RETURNS varchar AS $$
 DECLARE
@@ -936,7 +944,19 @@
 END;
 $$ LANGUAGE plpgsql stable strict;
 
+-- Backward compatibility definition for acs_object.name
+select define_function_args('acs_object__name','object_id');
 
+CREATE OR REPLACE FUNCTION acs_object__name(
+   name__object_id integer
+) RETURNS varchar AS $$
+BEGIN
+  RETURN acs_object.name(name__object_id);
+END;
+$$ LANGUAGE plpgsql stable strict;
+
+
+
 -- function default_name
 
 select define_function_args('acs_object__default_name','object_id');
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0d21-5.10.0d22.sql'.
Fisheye: No comparison available.  Pass `N' to diff?