Index: openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql 15 Feb 2002 02:01:14 -0000 1.7 +++ openacs-4/packages/acs-admin/www/users/member-state-change-postgresql.xql 8 Nov 2010 23:09:10 -0000 1.8 @@ -8,7 +8,7 @@ select u.email_verified_p as email_verified_p_old, mr.member_state as member_state_old, per.first_names || ' ' || per.last_name as name, - part.email, mr.rel_id, u.oid as row_id + part.email, mr.rel_id from users u JOIN parties part on (part.party_id = u.user_id) JOIN persons per on (per.person_id = u.user_id)