Index: openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql,v diff -u -r1.17 -r1.17.2.1 --- openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql 6 Sep 2002 12:02:27 -0000 1.17 +++ openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql 12 Dec 2002 01:32:48 -0000 1.17.2.1 @@ -3,7 +3,7 @@ postgresql7.1 - + select content as file_from_db from cr_revisions @@ -13,7 +13,7 @@ - + select coalesce((select item_id from cr_items where name=:cumulative_path),0) @@ -22,7 +22,7 @@ - + select static_page__new_folder ( NULL, -- folder_id @@ -39,15 +39,15 @@ - + update cr_revisions set content = :sp_filename where revision_id = content_item__get_live_revisions(:static_page_id) - + select static_page_id, mtime as mtime_from_db from static_pages @@ -56,7 +56,7 @@ - + select static_page__new( :parent_folder_id, -- folder_id @@ -68,7 +68,7 @@ - + update cr_revisions set content = :sp_filename @@ -79,7 +79,7 @@ - + begin perform static_page__delete_stale_items(:sync_session_id,:package_id);