Index: openacs-4/packages/ams/sql/postgresql/ams-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/ams-package-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/ams/sql/postgresql/ams-package-create.sql	9 Feb 2006 23:30:03 -0000	1.9
+++ openacs-4/packages/ams/sql/postgresql/ams-package-create.sql	1 Dec 2006 16:48:34 -0000	1.10
@@ -115,9 +115,9 @@
         v_dynamic_p             boolean;
 begin
         select attribute_id, attribute_name, object_type, dynamic_p
-          info v_attribute_id, v_object_type, v_attribute_name, v_dynamic_p
+          into v_attribute_id, v_object_type, v_attribute_name, v_dynamic_p
           from ams_attributes
-         where ams_attribute_id = :ams_attribute_id;
+         where ams_attribute_id = p_ams_attribute_id;
 
         delete from ams_attribute_values where attribute_id = v_attribute_id;
 
@@ -208,13 +208,12 @@
   p_object_id              alias for $2;  
   v_value                  text;
 begin
-  val := ams_attribute_value__value(p_attribute_id,( select aav.value_id from ams_attribute_values aav where aav.object_id = p_object_id and aav.attribute_id = p_attribute_id));
+  v_value := ams_attribute_value__value(p_attribute_id,( select aav.value_id from ams_attribute_values aav where aav.object_id = p_object_id and aav.attribute_id = p_attribute_id));
 
   return v_value;
 end;' language 'plpgsql' stable strict;
 
 
-
 ------ Options                                        
 --------------------------------------------------------------------
 
@@ -755,4 +754,3 @@
     return v_next_instance;
 end;' language 'plpgsql';
 
-
Index: openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d12-1.1d13.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d12-1.1d13.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d12-1.1d13.sql	9 Feb 2006 23:30:03 -0000	1.2
+++ openacs-4/packages/ams/sql/postgresql/upgrade/upgrade-1.1d12-1.1d13.sql	1 Dec 2006 16:48:34 -0000	1.3
@@ -15,12 +15,11 @@
   p_object_id              alias for $2;  
   v_value                  text;
 begin
-  val := ams_attribute_value__value(p_attribute_id,( select aav.value_id from ams_attribute_values aav where aav.object_id = p_object_id and aav.attribute_id = p_attribute_id));
+  v_value := ams_attribute_value__value(p_attribute_id,( select aav.value_id from ams_attribute_values aav where aav.object_id = p_object_id and aav.attribute_id = p_attribute_id));
 
   return v_value;
 end;' language 'plpgsql' stable strict;
 
-
 create or replace function ams_value__postal_address_save (varchar,varchar,varchar,varchar,char(2),varchar,integer)
 returns integer as ' 
 declare