PG 7.1 appears to have fixed it "good enough for OpenACS 3.2", at least.
In the interim, another trick to pull is to do a "psql -f postgres.sql" in the /www/doc/sql directory of your OpenACS installation before running the dump restore. Then ignore any "duplicate function" type errors you get.