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.33 -r1.34
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	19 Jun 2002 19:42:20 -0000	1.33
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql	22 Jun 2002 21:26:12 -0000	1.34
@@ -1346,7 +1346,7 @@
 declare
     acs_object__update_last_modified__object_id     alias for $1; 
     acs_object__update_last_modified__last_modified alias for $2; -- default now()
-    v_parent_id                                     acs_objects.context_id%TYPE;
+    v_parent_id                                     integer;
     v_last_modified                                 timestamp;
 begin
     if acs_object__update_last_modified__last_modified is null then
@@ -1356,13 +1356,13 @@
     end if;
 
     update acs_objects
-    set acs_objects.last_modified = v_last_modified
-    where acs_objects.object_id = acs_object__update_last_modified__object_id;
+    set last_modified = v_last_modified
+    where object_id = acs_object__update_last_modified__object_id;
 
-    select acs_objects.context_id
+    select context_id
     into v_parent_id
     from acs_objects
-    where acs_objects.object_id = acs_object__update_last_modified__object_id;
+    where object_id = acs_object__update_last_modified__object_id;
 
     if v_parent_id is not null and v_parent_id != 0 then
         select acs_object__update_last_modified(v_parent_id, v_last_modified);
