What is the cvs version on acs-messaging/sql/postgresql/acs-messaging-packages.sql
http://cvs.openacs.org/cvs/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql
I'm running on 1.10.4.2
But maybe you should be on 1.11. The log message says:
"Patches to make OpenACS PG 7.3 compatible"