Index: openacs-4/packages/categories/sql/postgresql/category-tree-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/category-tree-package.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/categories/sql/postgresql/category-tree-package.sql	6 Nov 2008 15:39:47 -0000	1.11
+++ openacs-4/packages/categories/sql/postgresql/category-tree-package.sql	30 Jan 2009 02:59:51 -0000	1.12
@@ -214,7 +214,7 @@
 	end loop;
 
 	-- correct parent_ids
-	update categories c
+	update categories
 	set parent_id = (select t.category_id
 			from categories s, categories t
 			where s.category_id = c.parent_id
Index: openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql	6 Nov 2008 15:39:47 -0000	1.1
+++ openacs-4/packages/categories/sql/postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql	30 Jan 2009 02:59:51 -0000	1.2
@@ -37,7 +37,7 @@
 	end loop;
 
 	-- correct parent_ids
-	update categories c
+	update categories 
 	set parent_id = (select t.category_id
 			from categories s, categories t
 			where s.category_id = c.parent_id
@@ -60,4 +60,4 @@
 
        return 0;
 end;
-' language 'plpgsql';
\ No newline at end of file
+' language 'plpgsql';