Thanks Tilmann!
I made the changes you suggested and created a tcl wrapper that is called "cr_get_live_revision_from_url" so that it can be used from other cr front-ends ...
Patch is here: https://openacs.org/bugtracker/openacs/patch?patch_number=103
I have switched "title" and "filename" parameters in a couple of places in the fs PL/[PG]SQL api so that the virtual url stays the same even when a new revision is uploaded ... I am not entirely sure if it is that simple. I have tested it though and it seems to work. I have not been load testing it at all and I would appreciate it if someone has the opportunity to do some of that before we commit this patch.
I'm also a bit uncertain whether the upgrade script is OK on the oracle front. Could somebody verify if it is correct or not?
