Forum OpenACS Development: Re: postgresql 8.2 installation

Collapse
Posted by Iuri Sampaio on
so far,
in order to turn around the problem i downloaded openacs-core-5.3.0 from openacs website and I ran the installation process again.

I followed pg-82 scripts:
http://www.openacs.org/xowiki/How_to_install_in_Postgres_8%2ex

then i got the followed error. the function was created at psql "dbname", but it seems it didn't succeed:

[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Notice: --------------------------

[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Notice: 0

[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Notice: (1 row)

[30/Nov/2007:05:50:26][20206.3061529520][-conn:0-] Error: Error sourcing /usr/local/aolserver/servers/openacs/openacs/packages/acs-bootstrap-installer/installer/install.tcl:
psql:postgresql.sql:44: WARNING: nonstandard use of escape in a string literal
LINE 1: ...ion instr(varchar,char,integer,integer) returns integer as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:142: WARNING: nonstandard use of escape in a string literal
LINE 1: ...unction get_func_drop_command (varchar) returns varchar as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:172: WARNING: nonstandard use of \\ in a string literal
LINE 1: ...replace function drop_package (varchar) returns varchar as '
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
psql:postgresql.sql:172: WARNING: nonstandard use of \\ in a string literal
LINE 1: SELECT $1 || '\\_\\_' || '%'
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
QUERY: SELECT $1 || '\\_\\_' || '%'
CONTEXT: SQL statement in PL/PgSQL function "drop_package" near line 8
psql:postgresql.sql:201: WARNING: nonstandard use of escape in a string literal
LINE 1: ...reate or replace function number_src(text) returns text as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:251: WARNING: nonstandard use of escape in a string literal
LINE 1: ...on get_func_definition (varchar,oidvector) returns text as '
^
HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
psql:postgresql.sql:251: WARNING: nonstandard use of \' in a string literal
LINE 1: SELECT $1 || ') returns ' || $2 || ' as \'\n' || $3 |...
^
HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
QUERY: SELECT $1 || ') returns ' || $2 || ' as \'\n' || $3 || '\' language \'plpgsql\';'
CONTEXT: SQL statement in PL/PgSQL function "get_func_definition" near line 44
psql:postgresql.sql:251: WARNING: nonstandard use of \' in a string literal
LINE 1: ... || ') returns ' || $2 || ' as \'\n' || $3 || '\' langua...
^
HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...').
QUERY: SELECT $1 || ') returns ' || $2 || ' as \'\n' || $3 || '\' language \'plpgsql\';'
CONTEXT: SQL statement in PL/PgSQL function "get_func_definition" near line 44
psql:lob.sql:34: WARNING: changing return type of function on_lobs_delete from "opaque" to "trigger"
psql:acs-metadata-create.sql:85: WARNING: changing return type of function acs_object_type_insert_tr from "opaque" to "trigger"
psql:acs-metadata-create.sql:134: WARNING: changing return type of function acs_object_type_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:188: ERROR: missing FROM-clause entry for table "acs_attribute_id_seq"
LINE 1: select acs_attribute_id_seq.nextval from dual
^
QUERY: select acs_attribute_id_seq.nextval from dual
CONTEXT: PL/pgSQL function "acs_attribute__create_attribute" line 28 at SQL statement
PL/pgSQL function "inline_0" line 20 at assignment
psql:acs-objects-create.sql:254: WARNING: changing return type of function acs_objects_mod_ip_insert_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:269: WARNING: changing return type of function acs_objects_last_mod_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:307: WARNING: changing return type of function acs_objects_insert_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:355: WARNING: changing return type of function acs_objects_update_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:456: WARNING: changing return type of function acs_objects_context_id_in_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:528: WARNING: changing return type of function acs_objects_context_id_up_tr from "opaque" to "trigger"
psql:acs-objects-create.sql:540: WARNING: changing return type of function acs_objects_context_id_del_tr from "opaque" to "trigger"
psql:acs-relationships-create.sql:308: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_rel_type__create_type" line 23 at perform
psql:acs-relationships-create.sql:446: WARNING: changing return type of function acs_rels_in_tr from "opaque" to "trigger"
psql:authentication-create.sql:92: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
psql:community-core-create.sql:237: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'party', '#acs-kernel.Party#', '#acs-kernel.Parties#', 'acs_object', 'parties', 'party_id', 'party', 'f', null, 'party__name' )"
PL/pgSQL function "inline_0" line 7 at perform
psql:community-core-create.sql:547: ERROR: insert or update on table "acs_object_type_tables" violates foreign key constraint "acs_obj_type_tbls_obj_type_fk"
DETAIL: Key (object_type)=(user) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_type_tables (object_type, table_name, id_column) values ('user', 'user_preferences', 'user_id')"
PL/pgSQL function "inline_1" line 3 at SQL statement
psql:groups-create.sql:158: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(party) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_0" line 7 at assignment
psql:groups-create.sql:424: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger"
psql:groups-create.sql:439: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger"
psql:groups-create.sql:452: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
LINE 4: (acs_object_id_seq.nextval, 'membership_rel', 'group');
^
psql:groups-create.sql:457: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
LINE 4: (acs_object_id_seq.nextval, 'composition_rel', 'group');
^
psql:rel-segments-create.sql:42: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(party) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'rel_segment', '#acs-kernel.lt_Relational_Party_Segm#', '#acs-kernel.lt_Relational_Party_Segm_1#', 'party', 'rel_segments', 'segment_id', 'rel_segment', 'f', null, 'rel_segment__name' )"
PL/pgSQL function "inline_0" line 7 at perform
psql:rel-segments-create.sql:292: WARNING: changing return type of function parties_in_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:306: WARNING: changing return type of function parties_del_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:329: WARNING: changing return type of function rel_segments_in_tr from "opaque" to "trigger"
psql:rel-segments-create.sql:346: WARNING: changing return type of function rel_segments_del_tr from "opaque" to "trigger"
psql:rel-constraints-create.sql:39: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'rel_constraint', '#acs-kernel.lt_Relational_Constraint#', '#acs-kernel.lt_Relational_Constraint_1#', 'acs_object', 'rel_constraints', 'constraint_id', 'rel_constraint', 'f', null, null )"
PL/pgSQL function "inline_0" line 2 at perform
psql:rel-constraints-create.sql:540: WARNING: changing return type of function rel_constraints_ins_tr from "opaque" to "trigger"
psql:rel-constraints-create.sql:590: WARNING: changing return type of function rel_constraints_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:184: WARNING: changing return type of function acs_priv_hier_ins_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:198: WARNING: changing return type of function acs_priv_del_tr from "opaque" to "trigger"
psql:acs-permissions-create.sql:421: WARNING: changing return type of function acs_permissions_lock_tr from "opaque" to "trigger"
psql:groups-body-create.sql:86: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger"
psql:groups-body-create.sql:113: WARNING: changing return type of function membership_rels_up_tr from "opaque" to "trigger"
psql:groups-body-create.sql:141: WARNING: changing return type of function membership_rels_del_tr from "opaque" to "trigger"
psql:groups-body-create.sql:250: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger"
psql:groups-body-create.sql:350: WARNING: changing return type of function composition_rels_del_tr from "opaque" to "trigger"
psql:journal-create.sql:35: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'journal_entry', 'Journal Entry', 'Journal Entries', 'acs_object', 'journal_entries', 'journal_id', 'journal_entry', 'f', null, null )"
PL/pgSQL function "inline_0" line 2 at perform
psql:site-nodes-create.sql:30: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'site_node', 'Site Node', 'Site Nodes', 'acs_object', 'site_nodes', 'node_id', 'site_node', 'f', null, null )"
PL/pgSQL function "inline_0" line 4 at perform
psql:site-nodes-create.sql:99: WARNING: changing return type of function site_node_insert_tr from "opaque" to "trigger"
psql:site-nodes-create.sql:159: WARNING: changing return type of function site_node_update_tr from "opaque" to "trigger"
psql:apm-create.sql:97: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
SQL statement "SELECT acs_object_type__create_type ( 'apm_package', 'Package', 'Packages', 'acs_object', 'apm_packages', 'package_id', 'apm_package', 'f', 'apm_package_types', 'apm_package__name' )"
PL/pgSQL function "inline_0" line 3 at perform
psql:apm-create.sql:129: ERROR: missing FROM-clause entry for table "acs_attribute_id_seq"
LINE 1: select acs_attribute_id_seq.nextval from dual
^
QUERY: select acs_attribute_id_seq.nextval from dual
CONTEXT: PL/pgSQL function "acs_attribute__create_attribute" line 28 at SQL statement
PL/pgSQL function "inline_1" line 5 at assignment
psql:apm-create.sql:588: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_2" line 4 at assignment
psql:apm-create.sql:884: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_4" line 4 at assignment
psql:apm-create.sql:961: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_5" line 4 at assignment
psql:apm-create.sql:1038: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(apm_package) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_6" line 5 at assignment
psql:apm-create.sql:1068: ERROR: insert or update on table "acs_object_types" violates foreign key constraint "acs_object_types_supertype_fk"
DETAIL: Key (supertype)=(apm_package) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_object_types (object_type, pretty_name, pretty_plural, supertype, table_name, id_column, abstract_p, type_extension_table, package_name, name_method) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 )"
PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement
PL/pgSQL function "inline_7" line 5 at assignment
psql:acs-create.sql:213: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "inline_0" line 5 at assignment
psql:acs-create.sql:315: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(user) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_objects (object_id, object_type, title) values (0, 'user', '#acs-kernel.Unregistered_Visitor#')"
PL/pgSQL function "inline_2" line 8 at SQL statement
psql:acs-create.sql:360: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(group) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "party__new" line 12 at assignment
PL/pgSQL function "acs_group__new" line 16 at assignment
PL/pgSQL function "inline_3" line 8 at assignment
psql:acs-create.sql:372: ERROR: insert or update on table "acs_objects" violates foreign key constraint "acs_objects_object_type_fk"
DETAIL: Key (object_type)=(acs_object) is not present in table "acs_object_types".
CONTEXT: SQL statement "INSERT INTO acs_objects (object_id, object_type, title, package_id, context_id, creation_date, creation_user, creation_ip, security_inherit_p) values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 )"
PL/pgSQL function "acs_object__new" line 40 at SQL statement
PL/pgSQL function "acs_object__new" line 10 at return
psql:acs-create.sql:377: ERROR: insert or update on table "acs_magic_objects" violates foreign key constraint "acs_magic_objects_object_id_fk"
DETAIL: Key (object_id)=(-3) is not present in table "acs_objects".
psql:acs-create.sql:404: ERROR: missing FROM-clause entry for table "acs_object_id_seq"
LINE 1: select acs_object_id_seq.nextval from dual
^
QUERY: select acs_object_id_seq.nextval from dual
CONTEXT: PL/pgSQL function "acs_object__new" line 17 at SQL statement
PL/pgSQL function "authority__new" line 38 at assignment

invoked from within
"db_source_sql_file -callback apm_ns_write_callback acs-kernel-create.sql"
(procedure "install_do_data_model_install" line 7)
invoked from within
"install_do_data_model_install"
invoked from within
"if { ![install_good_data_model_p] } {
install_do_data_model_install
} else {
ns_write "Kernel data model already installed."
# If kernel i..."
(file "/usr/local/aolserver/servers/openacs/openacs/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
invoked from within
"source $__file "
[30/Nov/2007:05:52:25][20206.3061529520][-conn:0-] Notice: exiting: timeout waiting for connection