Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql 10 Sep 2003 08:40:59 -0000 1.5 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql 30 Sep 2003 09:32:48 -0000 1.6 @@ -190,10 +190,6 @@ null, -- register_impl_id null, -- register_url null, -- help_contact_text - null, -- get_doc_impl_id - null, -- process_doc_impl_id - 'f', -- snapshot_p - 'f', -- batch_sync_enabled_p null, -- creation_user null, -- creation_ip null -- context_id @@ -208,7 +204,8 @@ alter table users add username varchar(100); update users set username = (select email from parties where party_id = users.user_id); -alter table users alter column username set not null; +-- Does not work with PG 7.2 +-- alter table users alter column username set not null; alter table users add constraint users_authority_username_un unique (authority_id, username);