Index: openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d1-5.1.0d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d1-5.1.0d2.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d1-5.1.0d2.sql 29 Jun 2004 10:18:24 -0000 1.4 +++ openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0d1-5.1.0d2.sql 13 Jan 2005 13:58:11 -0000 1.5 @@ -46,7 +46,7 @@ end;' language 'plpgsql' with (iscachable); -drop function file_storage__new_root_folder (integer); +-- drop function file_storage__new_root_folder (integer); create or replace function file_storage__new_file( -- @@ -609,30 +609,4 @@ return v_title; end;' language 'plpgsql'; - -create function inline_0 () returns integer as ' -declare - v_item_row record; -begin - for v_item_row in select - r.item_id, r.revision_id, r.title, i.name, i.live_revision - from cr_items i, cr_revisions r - where i.item_id=r.item_id - and i.live_revision=r.revision_id - and i.content_type=''file_storage_object'' - loop - - update cr_items set name=v_item_row.name - where item_id=v_item_row.item_id; - - update cr_revisions set title=v_item_row.title - where revision_id=v_item_row.revision_id; - - end loop; - -return null; -end;' language 'plpgsql'; - -select inline_0(); - -drop function inline_0(); +-- name title switch script moved to a6-a7 upgrade \ No newline at end of file