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.19.2.1 --- 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 9 Aug 2005 18:42:51 -0000 1.19.2.1 @@ -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) Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0a3-5.2.0a4.sql'. Fisheye: No comparison available. Pass `N' to diff?