That's weird. For starters, how about creating a new db, doing a
fresh install of the ACS without the postgres-pgtcl.sql functions, and
then see if things work? This way you can test a bit without
destroying your current OpenACS installation.
You're running PG 7.0.3, I presume?