Index: openacs-4/packages/organizations/organizations.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/organizations.info,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/organizations/organizations.info	27 May 2004 23:49:30 -0000	1.5
+++ openacs-4/packages/organizations/organizations.info	25 Jun 2004 17:09:54 -0000	1.6
@@ -7,11 +7,11 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="0.3d" url="http://openacs.org/repository/download/apm/organizations-0.3d.apm">
+    <version name="0.4d" url="http://openacs.org/repository/download/apm/organizations-0.4d.apm">
         <owner url="mailto:jon@mayuli.com">Jon Griffin</owner>
         <owner url="mailto:jader@bread.com">Jade Rubick</owner>
         <summary>Implementation of HR-XML organizations datamodel.</summary>
-        <release-date>2004-05-26</release-date>
+        <release-date>2004-06-25</release-date>
         <vendor url="http://www.mayuli.com">Mayuli Enterprises, LLC</vendor>
         <description format="text/plain">Provides the datamodel for an
       implementation of the HR-XML organizations spec, but no API for
@@ -20,7 +20,7 @@
       what needs to be updated to make things work correctly [Jade Rubick].
         </description>
 
-        <provides url="organizations" version="0.3d"/>
+        <provides url="organizations" version="0.4d"/>
         <requires url="acs-kernel" version="5.0d13"/>
 
         <callbacks>
Index: openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql	6 Mar 2004 22:53:24 -0000	1.3
+++ openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql	25 Jun 2004 17:09:54 -0000	1.4
@@ -184,7 +184,7 @@
     p_organization_id    alias for $1;
     v_organization_name  organizations.name%TYPE;
 begin
-        select name into v_organization_name
+        select name || ''_'' || organization_id into v_organization_name
                 from organizations
                 where organization_id = p_organization_id;
     return v_organization_name;
Index: openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.3d-0.4d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.3d-0.4d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.3d-0.4d.sql	25 Jun 2004 17:09:54 -0000	1.1
@@ -0,0 +1,22 @@
+-- 
+-- 
+-- 
+-- @author Jade Rubick (jader@bread.com)
+-- @creation-date 2004-06-25
+-- @arch-tag: 07f8a128-3ba4-411b-af7a-4ced0c68278b
+-- @cvs-id $Id: upgrade-0.3d-0.4d.sql,v 1.1 2004/06/25 17:09:54 jader Exp $
+--
+
+create or replace function organization__name (integer)
+returns varchar as '
+declare
+    p_organization_id    alias for $1;
+    v_organization_name  organizations.name%TYPE;
+begin
+        select name || ''_'' || organization_id into v_organization_name
+                from organizations
+                where organization_id = p_organization_id;
+    return v_organization_name;
+end;
+' language 'plpgsql';
+------ end name proc