Index: openacs-4/packages/new-portal/sql/postgresql/api-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/postgresql/api-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/new-portal/sql/postgresql/api-create.sql	29 May 2003 18:04:55 -0000	1.11
+++ openacs-4/packages/new-portal/sql/postgresql/api-create.sql	29 Jun 2004 10:18:37 -0000	1.12
@@ -110,11 +110,13 @@
 
             update portal_pages
             set sort_key = -1
-            where sort_key = i;
+            where sort_key = i
+	    and page_id = p_page_id;
 
             update portal_pages
             set sort_key = i - 1
-            where sort_key = -1;
+            where sort_key = -1
+	    and page_id = p_page_id;
 
         end if;