You need to load up postgresql.sql from the acs-kernel module to get around the function ordering problems.
We don't use PostgreSQL large objects. One reason we don't is that until 7.1 or so you couldn't dump them. We use something I wrote that functions at the AOLserver driver level and sites using them, for instance storing files in the database rather than file system, dump and restore fine.
