Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql,v
diff -u -r1.1.2.3 -r1.1.2.4
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql	13 Dec 2003 00:48:30 -0000	1.1.2.3
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0.0b3-5.0.0b4.sql	15 Dec 2003 00:30:31 -0000	1.1.2.4
@@ -772,7 +772,8 @@
 
 ---- DRB: fixes bug 1144
 
-create or replace view registered_users
+drop view registered_users;
+create view registered_users
 as
   select p.email, p.url, pe.first_names, pe.last_name, u.*, mr.member_state
   from parties p, persons pe, users u, group_member_map m, membership_rels mr, acs_magic_objects amo
@@ -787,7 +788,9 @@
   and mr.member_state = 'approved'
   and u.email_verified_p = 't';
 
-create or replace view cc_users
+
+drop view cc_users;
+create view cc_users
 as
 select o.*, pa.*, pe.*, u.*, mr.member_state, mr.rel_id
 from acs_objects o, parties pa, persons pe, users u, group_member_map m, membership_rels mr, acs_magic_objects amo