Forum OpenACS Development: Response to content_revision deleting

Posted by Dan Wickstrom on
Try modifying static_page__delete so that it sets live_revision null if the static page is the live revision, and if the static page is the latest revision, set the latest_revision to the next latest revision if other revisions exist - otherwise set the latest_revision to null.

It would be nice to be able to use the RI features here, but in this particular case, postgresql is kind of broken.  If you have RI triggers on latest and live revision, the RI triggers think that live and latest revision point to something even if you set them to null during the transaction.  I've reimplemented the RI triggers using regular user-level triggers to avoid this particular bug.