Switch the flag "add_missing_from" in the postgres config on and these things will work (see
https://openacs.org/xowiki/How_to_install_in_Postgres_8.x)
acs-core should be free from this kind of legacy stuff, i did not go through all application packages when i fixed these some time ago.