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 -N -r1.8 -r1.9
--- openacs-4/packages/categories/sql/postgresql/category-tree-package.sql	6 Feb 2005 18:42:19 -0000	1.8
+++ openacs-4/packages/categories/sql/postgresql/category-tree-package.sql	31 Jul 2006 20:31:11 -0000	1.9
@@ -213,7 +213,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