Index: openacs-4/packages/dotlrn/sql/postgresql/privacy-init.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/privacy-init.sql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/dotlrn/sql/postgresql/privacy-init.sql 1 Nov 2013 21:08:29 -0000 1.3 +++ openacs-4/packages/dotlrn/sql/postgresql/privacy-init.sql 7 Aug 2017 23:48:09 -0000 1.4 @@ -45,7 +45,7 @@ 'group', null, 0, - null, + null::integer, 'user', null, 0, @@ -73,7 +73,7 @@ 'group', null, 0, - null, + null::integer, 'user', null, 0, @@ -97,7 +97,7 @@ create or replace view dotlrn_guest_status as select r.object_id_two as user_id, - case when r.rel_type = 'dotlrn_guest_rel' then 't' else 'f' end as guest_p + case when r.rel_type = 'dotlrn_guest_rel' then true else false end as guest_p from acs_rels r, membership_rels m where m.rel_id = r.rel_id