Index: openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql,v diff -u -N -r1.9.10.1 -r1.9.10.2 --- openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql 26 Jul 2019 11:11:36 -0000 1.9.10.1 +++ openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql 26 Jul 2019 11:12:11 -0000 1.9.10.2 @@ -20,22 +20,6 @@ -- weren't created in the original ACS 4.2 Oracle sources. -- \i user-profiles-create.sql --- This view lets us avoid using acs_object.name to get party_names. --- --- create or replace view party_names --- as --- select p.party_id, --- decode(groups.group_id, --- null, decode(persons.person_id, --- null, p.email, --- persons.first_names || ' ' || persons.last_name), --- groups.group_name) as party_name --- from parties p, --- groups, --- persons --- where p.party_id = groups.group_id(+) --- and p.party_id = persons.person_id(+); - create view party_names as select p.party_id,