Jade, thanks for asking...
No, I haven't. I'm coming to the conclusion I need to install 4.6 from scratch. I mean, I've read vague references to upgrade scripts here and there, but I am supposing these would be version specific to dump data to temp files, drop old tables, alter changed tables, add new tables, and then load the dumped data into the updated database.
But the only documentation I've found is for a new install. Nothing about SW component updates/upgrades. I mean, it is obvious from these message boards that whenever a component of OpenACS changes (Aolserver, Postgres, Oracle, or the ToolKit) then updates or adjustments must be made to everything else, well maybe not Aolserver, but everything else.
Personally, I am a pretty decent Installer, I've installed OpenACS enough, but we are running a vanilla installation of the old ver. 3 at work and I'm hesitant to attempt an upgrade to 4.6 without a better understanding of the process to upgrade without losing data. I'm using 4.5 at home, and again, the major component versions are changing. The intiall install docs are very good, but I personally am at a loss when it comes to upgrading to the next level.