Index: openacs-4/packages/categories/www/cadmin/category-link-add-4-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/categories/www/cadmin/category-link-add-4-postgresql.xql,v diff -u -N --- openacs-4/packages/categories/www/cadmin/category-link-add-4-postgresql.xql 8 Feb 2004 17:30:45 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,40 +0,0 @@ - - - - postgresql7.1 - - - - - select c.category_id as link_category_id - from categories c - where c.category_id in ([join $link_category_id ,]) - and acs_permission__permission_p(c.tree_id,:user_id,'category_tree_write') = 't' - and c.category_id <> :category_id - and not exists (select 1 - from category_links l - where l.from_category_id = :category_id - and l.to_category_id = c.category_id) - - - - - - - - - select c.category_id as link_category_id - from categories c - where c.category_id in ([join $link_category_id ,]) - and acs_permission__permission_p(c.tree_id,:user_id,'category_tree_write') = 't' - and c.category_id <> :category_id - and not exists (select 1 - from category_links l - where l.from_category_id = c.category_id - and l.to_category_id = :category_id) - - - - - -