If you upgrade your RPM-based PG installation from 7.1 to 7.1.2, this breaks OpenACS 3.2.5 (and all other PG databases that use plpgsql.so too, as far as I can see!).
The quick fix is:
cp -p /usr/lib/pgsql/plpgsql.so /usr/lib /sbin/ldconfig
The better fix is probably to do something like
drop language 'plpgsql'; drop function plpgsql_call_handler();
in psql connected to the ACS database, and then use createlang to add the language back in again... but then a zillion OID references in pg_proc.prolang will need fixing up! So maybe the 'quick fix' is adequate??
Does anyone have any better ideas on dealing with this?