I'm getting inconsistent results trying to install some packages. It looks like an install partially succeeds (with an error), just enough to tell the package manager not to allow further attempts for that package. Is there a way to uninstall packages that haven't been recognized as installed? I see drop scripts in the package dirs. Can those be run from the command line, and if so, how?
Server installed using G Wong's FreeBSD guide and Postgresql 7.3.2. I'm also thinking that I should back up to Postgresql 7.2.x.
Here's an example:
Installing packages...
* Installing data model for Reference Data - Language 0.1d...
o Loading data model /web/openacs-4/packages/ref-language/sql/postgresql/ref-language-create.sql...
COMMENT
COMMENT
COMMENT
BEGIN
COMMIT
COMMIT
HTTP/1.0 200 OK
Server: AOLserver/3.4.2
MIME-Version: 1.0
Date: Mon, 10 Feb 2003 15:32:17 GMT
Content-Type: text/html
Content-Length: 21263
Connection: close
Request Error
psql:ref-language-create.sql:19: ERROR: Relation 'language_codes' already exists
psql:ref-language-create.sql:41: WARNING: Error occurred while executing PL/pgSQL function acs_reference__new
psql:ref-language-create.sql:41: WARNING: line 9 at return
psql:ref-language-create.sql:41: ERROR: Function acs_reference__new("unknown", character varying, "unknown", "unknown", "unknown", character varying, character varying, timestamptz, "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
psql:../common/ref-language-data.sql:8: ERROR: Cannot insert a duplicate key into unique index language_codes_language_id_pk
psql:../common/ref-language-data.sql:9: ERROR: current transaction is aborted, queries ignored until end of transaction block
psql:../common/ref-language-data.sql:10: ERROR: current transaction is aborted, queries ignored until end of transaction block
psql:../common/ref-language-data.sql:11: ERROR: current transaction is aborted, queries ignored until end of transaction block
psql:../common/ref-language-data.sql:12: ERROR: current transaction is aborted, queries ignored until end of transaction block
psql:../common/ref-language-data.sql:13: ERROR: current transaction is aborted, queries ignored until end of transaction block
psql:../common/ref-language-data.sql:14: ERROR: current transaction is aborted, queries ignored until end of transaction block