Forum OpenACS Development: Re: PostgreSQL 7.4RC1 problems

Collapse
Posted by Guan Yang on
Here's the rest, forgot it before. It mentions acs_priv_hier_priv_fk, but I'm not sure that's the problem.

psql:acs-create.sql:188: ERROR:  operator is not unique: bit varying || "unknown"
HINT:  Could not choose a best candidate operator. You may need to add explicit type casts.
CONTEXT:  PL/pgSQL function "tree_right" line 12 at return
PL/pgSQL function "acs_priv_hier_ins_del_tr" line 61 at SQL statement
psql:acs-create.sql:189: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:acs-create.sql:190: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:acs-create.sql:191: ERROR:  current transaction is aborted, commands ignored until end of transaction block
CONTEXT:  PL/pgSQL function "acs_object__new" line 12 at select into variables
PL/pgSQL function "acs_rel__new" line 13 at assignment
PL/pgSQL function "membership_rel__new" line 11 at assignment
PL/pgSQL function "inline_2" line 54 at perform
psql:acs-create-2.sql:17: ERROR:  insert or update on table "acs_privilege_hierarchy" violates foreign key constraint "acs_priv_hier_priv_fk"
DETAIL:  Key (privilege)=(admin) is not present in table "acs_privileges".

    invoked from within
"db_source_sql_file -callback apm_ns_write_callback "acs-kernel-create.sql""
    (file "/web/nadev/packages/acs-bootstrap-installer/installer/install-data-model.tcl" line 31)
    invoked from within
"source $__file "