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 -r1.9 -r1.9.10.1 --- openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql 8 Dec 2009 01:57:22 -0000 1.9 +++ openacs-4/packages/acs-subsite/sql/postgresql/acs-subsite-create.sql 26 Jul 2019 11:11:36 -0000 1.9.10.1 @@ -17,16 +17,16 @@ \i themes-create.sql -- DRB: user profiles are fundamentally broken, which is probably why they --- weren't created in the original ACS 4.2 Oracle sources. +-- 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, decode(persons.person_id, -- null, p.email, -- persons.first_names || ' ' || persons.last_name), -- groups.group_name) as party_name @@ -48,7 +48,7 @@ persons.first_names || ' ' || persons.last_name end) else - groups.group_name + groups.group_name end) as party_name from ((parties p left outer join groups on p.party_id = groups.group_id) left outer join persons on p.party_id = persons.person_id);