When I try to bootstrap my ACS installation, it craps out on (the first sql file read?) postgres.sql, complaining that it can't create a function because the language plpgsql is unrecognized. Hmm.. since this is a fresh install of postgres, I checked my LD_LIBRARY_PATH, but the library file plpgsql.so is there. So I checked postgres.sql. Unlike openacs-3.2.4, there is no explicit creation of the plpgsql language, along the lines of
create function plpgsql_call_handler() RETURNS opaque as '/usr/local/pgsql/lib/plpgsql.so' language 'c'; create trusted procedural language 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL';I logged in my database and typed the above manually, and restarted the bootstrap process. Sure enough, the bootstrapping process went on until the "restart aolserver" page (i.e., a successful install).
So, why isn't the creation of the plpgsl "handler" not in postgres.sql? Did I miss something in my installation of postgres? aolserver? We should probably note something in the installation instructions.
BTW, I am really impressed how far along the port has progressed. Good work, guys! I have oracle and postgres, so I should be able to help out in the testing and probably porting.