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/Attic/upgrade-5.10.0-5.10.1d1.sql,v diff -u -N -r1.1.2.3 -r1.1.2.4 --- 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 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.0-5.10.1d1.sql 2 Mar 2022 17:41:13 -0000 1.1.2.4 @@ -11,7 +11,6 @@ DROP VIEW acs_users_all; DROP VIEW cc_users; -DROP VIEW registered_users; -- -- Some legacy applications might contain still the VIEW @@ -26,6 +25,13 @@ -- DROP VIEW IF EXISTS registered_users_of_package_id; +-- +-- In case, the legacy view registered_users_of_package_id was in +-- place, it has to be dropped before registered_users. +-- +DROP VIEW registered_users; + + ALTER TABLE users ALTER COLUMN password TYPE character varying(128); CREATE VIEW acs_users_all AS