Well, i was annoyed by this as well for a while and devoted my weekend for the problem. The result is in CVS head and removes the "missing FROM-clause" messages in PostgreSQL (no changes for Oracle necessary).
The messages are mostly due to an old, deprecated syntax of pg, which pops up in connection with sequences (but not only, as well on the global constants of the content repository). While i was at it, i updated as well some of the sequence interfaces. For example db_nextval acs_object_id_seq
is now more than twice as fast than before (before: 948 microseconds, now: 378 microseconds). I have tried to be as careful as possible and not to break existing code. The new version runs the regression test of the acs-kernel modules like before; i tested upgrade and fresh installs.
Actually, for most purposes, we could now get rid of the special postgres config flag
add_missing_from = on
but since i have only tested the kernel-module regression tests and xotcl-core and xowiki, it can be that in some other acs packages there are still dependencies on that flag.
Since the change effects pretty basic functions of openacs (e.g. 00-database-procs.tcl, acs_object__new(), content_item__new(), ...) i have committed these changes in a single commit, such that one can more easily undo my changes in case of troubles.
http://xarg.net/tools/cvs/change-set-details?key=28379