Forum .LRN Q&A: Response to problems with PG7.2.1 + AOL server3.4.2

Collapse
Posted by Jeff Davis on
Rafael, you should be able to do this to fix the autosubscribe_p error:
alter table forums_forums add autosubscribe_p                 char(1)
                                     constraint forums_autosubscribe_p_ck
                                     check (autosubscribe_p in ('t','f'));
update forums_forums set autosubscribe_p = 'f' 
 where autosubscribe_p is null;
alter table forums_forums alter column autosubscribe_p  SET DEFAULT 'f';
(I added this to dotlrn-forums-create.sql as well).

I will check one the other error as well...