Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql,v
diff -u -r1.24 -r1.25
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	3 Dec 2003 23:38:27 -0000	1.24
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql	11 Dec 2003 21:39:52 -0000	1.25
@@ -138,7 +138,7 @@
 
     return magic_object_id__object_id;
    
-end;' language 'plpgsql' with(isstrict,iscachable);
+end;' language 'plpgsql' immutable strict;
 
 -- ******************************************************************
 -- * Community Core API
@@ -161,7 +161,7 @@
 
 -- faster simpler view
 -- does not check for registered user/banned etc
-create view all_users
+create or replace view acs_users_all
 as
 select pa.*, pe.*, u.*
 from  parties pa, persons pe, users u
@@ -180,8 +180,8 @@
   and amo.name = 'registered_users'
   and m.group_id = amo.object_id
   and m.rel_id = mr.rel_id
-  and m.rel_type = 'membership_rel'
-  and m.container_id = m.group_id;
+  and m.container_id = m.group_id
+  and m.rel_type = 'membership_rel';
 
 
 -----------------------------------