Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql	27 Oct 2021 12:47:54 -0000	1.1.2.2
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql	6 Dec 2021 09:42:47 -0000	1.1.2.3
@@ -11,9 +11,21 @@
 
 DROP VIEW acs_users_all;
 DROP VIEW cc_users;
-DROP VIEW registered_users_of_package_id;
 DROP VIEW registered_users;
 
+--
+-- Some legacy applications might contain still the VIEW
+-- "registered_users_of_package_id", which is defined in
+--
+--     acs-subsite/sql/postgresql/user-profiles-create.sql
+--
+-- This file is NOT included in new installations since over 20 years,
+-- so it is not maintained and treated as a leftover from ancient
+-- times.  Therefore, the view registered_users_of_package_id is not
+-- recreated by this update script.
+--
+DROP VIEW IF EXISTS registered_users_of_package_id;
+
 ALTER TABLE users ALTER COLUMN password TYPE character varying(128);
 
 CREATE VIEW acs_users_all AS
@@ -48,10 +60,11 @@
   and u.email_verified_p = 't';
 
 --
--- actually from acs-subsite (which is mandatory in acs-core)
+-- Actually from acs-subsite (which is mandatory in acs-core), but
+-- obsolete (see above).
 --
-CREATE VIEW registered_users_of_package_id AS
-  select u.*, au.package_id
-  from application_users au,
-       registered_users u
-  where au.user_id = u.user_id;
+-- CREATE VIEW registered_users_of_package_id AS
+--  select u.*, au.package_id
+--  from application_users au,
+--       registered_users u
+--  where au.user_id = u.user_id;