Forum .LRN Q&A: Permissions on Postgresql version of Forums

Collapse
1: Permissions on Postgresql version of Forums
Posted by Dave Bauer on 08/01/02 04:54 PM
There was a bug in the postgresql version of forums where context_id
was not getting set so that registered users could not view messages.
Has this been fixed?
Collapse
2: Context_id bug in forums for postgresql 7.1 (response to 1)
Posted by Dave Bauer on 08/03/02 06:14 PM

I have tracked down the context_id error in the postgresql version of forums, i think.

The pl/pgsql function forum_message__new takes context_id as an argument and uses that to set the context_id of the acs_object for the forums_message object. The oracle version of the function uses nvl(p_context_id, p_forum_id) so that if no context_id is passed, the forum_id is used.

I tried to copy this in postgresql using coalesce(p_context_id, p_forum_id) and it does the the context_id correctly.

The problem arises when 

perform acs_object__update_last_modified(p_forum_id);
is called. This error occurs: 
ERROR:  triggered data change violation on relation "acs_object_co
ntext_index"

Any ideas on how to fix this? Switch to postgresql 7.2?

Collapse
3: Response to Permissions on Postgresql version of Forums (response to 1)
Posted by Benjamin Bytheway on 08/05/02 05:12 PM
I noticed the context_id problem a few weeks ago.  Have you made any more progress identifying a fix for it? (This is what has been causing the permissions problems with forums I've been posting about for the past couple of months.)
Collapse
4: Response to Permissions on Postgresql version of Forums (response to 1)
Posted by Dave Bauer on 08/05/02 05:26 PM
Benjamin,

The fix I describe will work with postgresql 7.2. In forums_meesage__new change in the call to acs_object__new where it says p_context_id to
coalesce(p_context_id, p_forum_id)

The data change violation is caused by a bug in postgresql 7.1.

Collapse
5: Response to Permissions on Postgresql version of Forums (response to 1)
Posted by Benjamin Bytheway on 08/05/02 05:31 PM
Has the fix been committed to CVS?
Collapse
6: Response to Permissions on Postgresql version of Forums (response to 1)
Posted by Dave Bauer on 08/05/02 05:40 PM
Benjamin,

I am waiting for feedback from the designers of the forums package regarding this fix.

I haven't been able to test it, but it is an exact port of the behavior of the oracle version of the code.

Collapse
7: Response to Permissions on Postgresql version of Forums (response to 1)
Posted by Arjun Sanyal on 08/05/02 10:04 PM
dave: it's checked in and, by the way, forums_forum__new had the same issue.
Collapse
8: Response to Permissions on Postgresql version of Forums (response to 1)
Posted by Benjamin Bytheway on 08/05/02 10:09 PM
This is great news.  I've been waiting for this fix for a while now.  Now I have no excuse to put off getting started on that new website...