I just finished the integration of FAQ and Notifications. Now you can request a notification when a Q&A is posted or edited. You can request for a notification of a new Q&A on one specific FAQ or a new Q&A of any FAQ.
The integration between this two packages are made with service contracts tcl specs so it would have to work in postgres and in oracle as well.
This feature will be really useful for lightweight environments, because through email you'll get any kind of notification. You can find the code cvs.openacs.org at HEAD.