-- -- etp__create_symlink/2 -- create or replace function etp__create_symlink( integer, integer ) returns int4 as $$ declare p_package_id alias for $1; p_target_id alias for $2; v_item_id integer; v_folder_id integer; begin v_item_id := acs_object__new(null, 'content_symlink'); v_folder_id := etp__get_folder_id(p_package_id); insert into cr_items ( item_id, parent_id, name, content_type ) values ( v_item_id, v_folder_id, 'symlink ' || nextval('t_etp_auto_page_number_seq'), 'content_symlink' ); insert into cr_symlinks (symlink_id, target_id) values (v_item_id, p_target_id); return 1; end; $$ language plpgsql;