Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql,v diff -u -r1.19 -r1.20 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql 1 Jul 2004 16:33:38 -0000 1.19 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql 4 Jun 2006 00:45:23 -0000 1.20 @@ -155,15 +155,29 @@ delete__symlink_id alias for $1; begin + PERFORM content_symlink__del(delete__symlink_id); + + return 0; +end;' language 'plpgsql'; + + +select define_function_args('content_symlink__del','symlink_id'); +create or replace function content_symlink__del (integer) +returns integer as ' +declare + del__symlink_id alias for $1; +begin + delete from cr_symlinks - where symlink_id = delete__symlink_id; + where symlink_id = del__symlink_id; - PERFORM content_item__delete(delete__symlink_id); + PERFORM content_item__delete(del__symlink_id); return 0; end;' language 'plpgsql'; + -- function is_symlink select define_function_args('content_symlink__is_symlink','item_id'); create or replace function content_symlink__is_symlink (integer)