The old Oracle query is still inline in the Tcl script - I just checked, and while the oracle and postgres versions of the query do exist in the proper query files, the original inline query's not been cleaned out from the script.
My guess is that the query files aren't being loaded for some reason. That would cause the query dispatcher to use the inline query by default, which happens to be an Oracle query. Or that somehow acs-tcl/tcl/security-procs-postgresql.xql is missing for some reason (might as well check that first, it's easy)
Also ... depending on just when this site was created, it may not work out of the box on PG 7.2. Every major PG release - 6.5->7.0->7.1->7.2->7.3 - has brought incompatibilities that has forced us to rewrite some code. We generally try to support one full major release back (in other words 4.6.2 will support PG 7.2 and PG 7.3) but obviously we've not been able to predict exactly what new incompatibilities the PG group will introduce beforehand so can't guarantee forward compatibility.
So one question is whether or not the version of OpenACS these guys started with was one fixed to work with PG 7.2 or not ...
But regardless it should at least start up ...
