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.8 -r1.8.2.1 --- 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 8 Jun 2006 01:46:52 -0000 1.8.2.1 @@ -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