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.22 -r1.22.2.1 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 6 Oct 2003 13:16:11 -0000 1.22 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-create.sql 20 Nov 2003 21:24:03 -0000 1.22.2.1 @@ -159,7 +159,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