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.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