Forum OpenACS Development: import database

Collapse
1: import database
Posted by Iuri Sampaio on 02/08/08 09:20 PM
I've got unusual error messages import a database backup

it seems ltree is generating duplicate keys, what there is no reason since the database is clean and emtpy.
After drop the old one:
dropdb openacs

I created a fresh one: createdb -E UNICODE openacs

then i imported a copy created as follow:
$ pg_dump openacs > openacs-backup.dmp

then when i ran:
$ psql -f openacs-backup.dmp openacs

i got the errors bellow. it seems there is no effect to the system. I set up the website and it's running fine. I am afraid it had further consequences, which i am don;t see at the moment. Is that a possibility?

openacs@debian:~$ psql -f database-backup/openacs-2008-01-31-08-37.dmp openacs > importdb
psql:database-backup/openacs-2008-01-31-08-37.dmp:22: ERROR: language "plpgsql" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:31: ERROR: type "gtsq" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:40: ERROR: function "gtsq_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:51: ERROR: function "gtsq_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:66: ERROR: type "gtsq" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:75: ERROR: type "gtsvector" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:84: ERROR: function "gtsvector_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:95: ERROR: function "gtsvector_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:110: ERROR: type "gtsvector" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:119: ERROR: type "lquery" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:128: ERROR: function "lquery_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:139: ERROR: function "lquery_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:154: ERROR: type "lquery" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:163: ERROR: type "ltree" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:172: ERROR: function "ltree_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:183: ERROR: function "ltree_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:198: ERROR: type "ltree" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:207: ERROR: type "ltree_gist" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:216: ERROR: function "ltree_gist_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:227: ERROR: function "ltree_gist_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:242: ERROR: type "ltree_gist" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:251: ERROR: type "ltxtquery" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:260: ERROR: function "ltxtq_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:271: ERROR: function "ltxtq_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:286: ERROR: type "ltxtquery" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:295: ERROR: type "tsquery" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:304: ERROR: function "tsquery_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:315: ERROR: function "tsquery_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:330: ERROR: type "tsquery" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:339: ERROR: type "tsvector" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:348: ERROR: function "tsvector_in" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:359: ERROR: function "tsvector_out" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:374: ERROR: type "tsvector" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:387: ERROR: relation "statinfo" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:399: ERROR: relation "tokenout" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:412: ERROR: relation "tokentype" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:428: ERROR: relation "tsdebug" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:439: ERROR: function "_get_parser_from_curcfg" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:450: ERROR: function "_lt_q_regex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:461: ERROR: function "_lt_q_rregex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:472: ERROR: function "_ltq_extract_regex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:483: ERROR: function "_ltq_regex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:494: ERROR: function "_ltq_rregex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:505: ERROR: function "_ltree_compress" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:516: ERROR: function "_ltree_consistent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:527: ERROR: function "_ltree_extract_isparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:538: ERROR: function "_ltree_extract_risparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:549: ERROR: function "_ltree_isparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:560: ERROR: function "_ltree_penalty" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:571: ERROR: function "_ltree_picksplit" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:582: ERROR: function "_ltree_r_isparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:593: ERROR: function "_ltree_r_risparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:604: ERROR: function "_ltree_risparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:615: ERROR: function "_ltree_same" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:626: ERROR: function "_ltree_union" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:637: ERROR: function "_ltxtq_exec" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:648: ERROR: function "_ltxtq_extract_exec" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:659: ERROR: function "_ltxtq_rexec" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:10606: ERROR: function "concat" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:18923: ERROR: function "dex_init" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:18934: ERROR: function "dex_lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:19084: ERROR: function "exectsq" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:19946: ERROR: function "get_covers" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20092: ERROR: function "gin_extract_tsquery" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20103: ERROR: function "gin_extract_tsvector" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20114: ERROR: function "gin_ts_consistent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20170: ERROR: function "gtsq_compress" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20181: ERROR: function "gtsq_consistent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20192: ERROR: function "gtsq_decompress" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20203: ERROR: function "gtsq_penalty" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20214: ERROR: function "gtsq_picksplit" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20225: ERROR: function "gtsq_same" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20236: ERROR: function "gtsq_union" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20247: ERROR: function "gtsvector_compress" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20258: ERROR: function "gtsvector_consistent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20269: ERROR: function "gtsvector_decompress" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20280: ERROR: function "gtsvector_penalty" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20291: ERROR: function "gtsvector_picksplit" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20302: ERROR: function "gtsvector_same" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20313: ERROR: function "gtsvector_union" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20324: ERROR: function "headline" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20335: ERROR: function "headline" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20346: ERROR: function "headline" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20357: ERROR: function "headline" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20368: ERROR: function "headline" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20379: ERROR: function "headline" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20859: ERROR: function "index" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:20870: ERROR: function "index" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21127: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21138: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21149: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21160: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21171: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21182: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21193: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21204: ERROR: function "lca" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21215: ERROR: function "length" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21226: ERROR: function "lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21237: ERROR: function "lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21248: ERROR: function "lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21328: ERROR: function "lt_q_regex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21339: ERROR: function "lt_q_rregex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21350: ERROR: function "ltq_regex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21361: ERROR: function "ltq_rregex" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21372: ERROR: function "ltree2text" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21383: ERROR: function "ltree_addltree" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21394: ERROR: function "ltree_addtext" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21405: ERROR: function "ltree_cmp" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21416: ERROR: function "ltree_compress" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21427: ERROR: function "ltree_consistent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21438: ERROR: function "ltree_decompress" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21449: ERROR: function "ltree_eq" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21460: ERROR: function "ltree_ge" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21471: ERROR: function "ltree_gt" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21482: ERROR: function "ltree_isparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21493: ERROR: function "ltree_le" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21504: ERROR: function "ltree_lt" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21515: ERROR: function "ltree_ne" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21526: ERROR: function "ltree_penalty" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21537: ERROR: function "ltree_picksplit" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21548: ERROR: function "ltree_risparent" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21559: ERROR: function "ltree_same" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21570: ERROR: function "ltree_textadd" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21581: ERROR: function "ltree_union" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21592: ERROR: function "ltreeparentsel" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21603: ERROR: function "ltxtq_exec" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:21614: ERROR: function "ltxtq_rexec" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:22094: ERROR: function "nlevel" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:22568: ERROR: function "numnode" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:22632: ERROR: function "parse" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:22643: ERROR: function "parse" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:22654: ERROR: function "parse" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23042: ERROR: function "plainto_tsquery" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23053: ERROR: function "plainto_tsquery" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23064: ERROR: function "plainto_tsquery" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23138: ERROR: function "prsd_end" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23149: ERROR: function "prsd_getlexeme" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23160: ERROR: function "prsd_headline" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23171: ERROR: function "prsd_lextype" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23182: ERROR: function "prsd_start" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23193: ERROR: function "querytree" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23204: ERROR: function "rank" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23215: ERROR: function "rank" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23226: ERROR: function "rank" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23237: ERROR: function "rank" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23248: ERROR: function "rank_cd" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23259: ERROR: function "rank_cd" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23270: ERROR: function "rank_cd" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23281: ERROR: function "rank_cd" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23948: ERROR: function "reset_tsearch" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23959: ERROR: function "rewrite" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23970: ERROR: function "rewrite" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23981: ERROR: function "rewrite_accum" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:23992: ERROR: function "rewrite_finish" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24003: ERROR: function "rexectsq" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24199: ERROR: function "set_curcfg" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24210: ERROR: function "set_curcfg" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24221: ERROR: function "set_curdict" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24232: ERROR: function "set_curdict" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24243: ERROR: function "set_curprs" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24254: ERROR: function "set_curprs" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24265: ERROR: function "setweight" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24276: ERROR: function "show_curcfg" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24655: ERROR: function "snb_en_init" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24666: ERROR: function "snb_lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24677: ERROR: function "snb_ru_init_koi8" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24688: ERROR: function "snb_ru_init_utf8" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24699: ERROR: function "spell_init" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24710: ERROR: function "spell_lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24759: ERROR: function "stat" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24770: ERROR: function "stat" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24781: ERROR: function "strip" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24792: ERROR: function "subltree" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24803: ERROR: function "subpath" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24814: ERROR: function "subpath" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24899: ERROR: function "syn_init" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:24910: ERROR: function "syn_lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:25037: ERROR: function "text2ltree" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:25048: ERROR: function "thesaurus_init" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:25059: ERROR: function "thesaurus_lexize" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26243: ERROR: function "to_tsquery" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26254: ERROR: function "to_tsquery" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26265: ERROR: function "to_tsquery" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26276: ERROR: function "to_tsvector" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26287: ERROR: function "to_tsvector" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26298: ERROR: function "to_tsvector" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26309: ERROR: function "token_type" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26320: ERROR: function "token_type" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26331: ERROR: function "token_type" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26791: ERROR: function "ts_debug" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26802: ERROR: function "tsearch2" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26813: ERROR: function "tsq_mcontained" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26824: ERROR: function "tsq_mcontains" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26835: ERROR: function "tsquery_and" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26846: ERROR: function "tsquery_cmp" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26857: ERROR: function "tsquery_eq" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26868: ERROR: function "tsquery_ge" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26879: ERROR: function "tsquery_gt" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26890: ERROR: function "tsquery_le" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26901: ERROR: function "tsquery_lt" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26912: ERROR: function "tsquery_ne" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26923: ERROR: function "tsquery_not" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26934: ERROR: function "tsquery_or" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26945: ERROR: function "tsvector_cmp" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26956: ERROR: function "tsvector_eq" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26967: ERROR: function "tsvector_ge" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26978: ERROR: function "tsvector_gt" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:26989: ERROR: function "tsvector_le" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:27000: ERROR: function "tsvector_lt" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:27011: ERROR: function "tsvector_ne" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:27667: ERROR: function "rewrite" already exists with same argument types
psql:database-backup/openacs-2008-01-31-08-37.dmp:27679: ERROR: operator !! already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27695: ERROR: operator && already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27712: ERROR: operator < already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27729: ERROR: operator < already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27746: ERROR: operator < already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27763: ERROR: operator <= already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27780: ERROR: operator <= already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27797: ERROR: operator <= already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27814: ERROR: operator <> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27831: ERROR: operator <> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27848: ERROR: operator <> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27864: ERROR: operator <@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27880: ERROR: operator <@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27896: ERROR: operator <@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27912: ERROR: operator <@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27933: ERROR: operator = already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27954: ERROR: operator = already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27975: ERROR: operator = already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:27992: ERROR: operator > already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28009: ERROR: operator > already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28026: ERROR: operator > already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28043: ERROR: operator >= already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28060: ERROR: operator >= already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28077: ERROR: operator >= already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28093: ERROR: operator ? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28109: ERROR: operator ? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28125: ERROR: operator ? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28141: ERROR: operator ? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28154: ERROR: operator ?<@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28167: ERROR: operator ?@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28180: ERROR: operator ?@> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28193: ERROR: operator ?~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28209: ERROR: operator @ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28225: ERROR: operator @ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28241: ERROR: operator @ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28257: ERROR: operator @ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28273: ERROR: operator @ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28289: ERROR: operator @> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28305: ERROR: operator @> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28321: ERROR: operator @> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28337: ERROR: operator @> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28353: ERROR: operator @@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28369: ERROR: operator @@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28385: ERROR: operator @@@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28401: ERROR: operator @@@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28417: ERROR: operator ^<@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28433: ERROR: operator ^<@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28449: ERROR: operator ^<@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28465: ERROR: operator ^? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28481: ERROR: operator ^? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28497: ERROR: operator ^? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28513: ERROR: operator ^? already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28529: ERROR: operator ^@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28545: ERROR: operator ^@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28561: ERROR: operator ^@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28577: ERROR: operator ^@ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28593: ERROR: operator ^@> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28609: ERROR: operator ^@> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28625: ERROR: operator ^@> already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28641: ERROR: operator ^~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28657: ERROR: operator ^~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28673: ERROR: operator ^~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28689: ERROR: operator ^~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28702: ERROR: operator || already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28718: ERROR: operator || already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28731: ERROR: operator || already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28744: ERROR: operator || already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28757: ERROR: operator || already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28773: ERROR: operator ~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28789: ERROR: operator ~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28805: ERROR: operator ~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28821: ERROR: operator ~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28837: ERROR: operator ~ already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28854: ERROR: operator class "gin_tsvector_ops" for access method "gin" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28880: ERROR: operator class "gist__ltree_ops" for access method "gist" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28911: ERROR: operator class "gist_ltree_ops" for access method "gist" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28933: ERROR: operator class "gist_tp_tsquery_ops" for access method "gist" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28952: ERROR: operator class "gist_tsvector_ops" for access method "gist" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28968: ERROR: operator class "ltree_ops" for access method "btree" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:28984: ERROR: operator class "tsquery_ops" for access method "btree" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:29000: ERROR: operator class "tsvector_ops" for access method "btree" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:34513: ERROR: relation "pg_ts_cfg" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:34526: ERROR: relation "pg_ts_cfgmap" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:34541: ERROR: relation "pg_ts_dict" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:34558: ERROR: relation "pg_ts_parser" already exists
psql:database-backup/openacs-2008-01-31-08-37.dmp:45229: ERROR: duplicate key violates unique constraint "pg_ts_cfg_pkey"
CONTEXT: COPY pg_ts_cfg, line 1: "default default C"
psql:database-backup/openacs-2008-01-31-08-37.dmp:45313: ERROR: duplicate key violates unique constraint "pg_ts_cfgmap_pkey"
CONTEXT: COPY pg_ts_cfgmap, line 1: "default lword {en_stem}"
psql:database-backup/openacs-2008-01-31-08-37.dmp:45328: ERROR: duplicate key violates unique constraint "pg_ts_dict_pkey"
CONTEXT: COPY pg_ts_dict, line 1: "simple dex_init(internal) \N dex_lexize(internal,internal,integer) Simple example of dictionary."
psql:database-backup/openacs-2008-01-31-08-37.dmp:45337: ERROR: duplicate key violates unique constraint "pg_ts_parser_pkey"
CONTEXT: COPY pg_ts_parser, line 1: "default prsd_start(internal,integer) prsd_getlexeme(internal,internal,internal) prsd_end(internal) p..."
psql:database-backup/openacs-2008-01-31-08-37.dmp:84517: ERROR: multiple primary keys for table "pg_ts_cfg" are not allowed
psql:database-backup/openacs-2008-01-31-08-37.dmp:84525: ERROR: multiple primary keys for table "pg_ts_cfgmap" are not allowed
psql:database-backup/openacs-2008-01-31-08-37.dmp:84533: ERROR: multiple primary keys for table "pg_ts_dict" are not allowed
psql:database-backup/openacs-2008-01-31-08-37.dmp:84541: ERROR: multiple primary keys for table "pg_ts_parser" are not allowed
psql:database-backup/openacs-2008-01-31-08-37.dmp:88385: WARNING: foreign key constraint "rss_gen_subscrs_ctx_fk" will require costly sequential scans
DETAIL: Key columns "summary_context_id" and "object_id" are of different types: character varying and integer.
openacs@debian:~$

Collapse
2: Re: import database (response to 1)
Posted by Iuri Sampaio on 02/08/08 09:32 PM
so far,
i noticed some apis of notifications pkg, (such as
notification::sweep::sweep_notifications), generate errors more oftenly than before.

[08/Feb/2008:05:24:11][17018.3034266544][-sched:12-] Error: Ns_PgExec: result status: 7 message: ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^

[08/Feb/2008:05:24:11][17018.3034266544][-sched:12-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^
")

while executing
"ns_pg_bind select nsdb0 {
select
message_id as id,
creation_date,
locking_server,..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]

set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_queued_messages {} {
# check if record is already there and free to use
set return_id [db_string get_qu..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"with_finally -code {
db_foreach get_queued_messages {} {
# check if record is already there and free to use
..."
(procedure "acs_mail_lite::sweeper" line 8)
invoked from within
"acs_mail_lite::sweeper"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 acs_mail_lite::sweeper {} 1202476990 0 f}"
[08/Feb/2008:05:24:12][17018.3034266544][-sched:16-] Error: Ns_PgExec: result status: 7 message: ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^

[08/Feb/2008:05:24:12][17018.3034266544][-sched:16-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^
")

while executing
"ns_pg_bind select nsdb0 {
select notification_id,
notif_subject,
notif_text,
noti..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set result [list]
set selection [db_exec select $db $full_statement_name $sql]

while {[db_getro..."
(procedure "db_list_of_ns_sets" line 7)
invoked from within
"db_list_of_ns_sets select_notifications {}"
(procedure "notification::sweep::sweep_notifications" line 7)
invoked from within
"notification::sweep::sweep_notifications -interval_id 587 -batched_p 0"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 notification::sweep::sweep_notifications {-interval_id 587 -batched_p 0} 1202476992 0 f}"
[08/Feb/2008:05:25:11][17018.3034266544][-sched:12-] Error: Ns_PgExec: result status: 7 message: ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^

[08/Feb/2008:05:25:11][17018.3034266544][-sched:12-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^
")

while executing
"ns_pg_bind select nsdb0 {
select
message_id as id,
creation_date,
locking_server,..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]

set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_queued_messages {} {
# check if record is already there and free to use
set return_id [db_string get_qu..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"with_finally -code {
db_foreach get_queued_messages {} {
# check if record is already there and free to use
..."
(procedure "acs_mail_lite::sweeper" line 8)
invoked from within
"acs_mail_lite::sweeper"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 acs_mail_lite::sweeper {} 1202476990 0 f}"
[08/Feb/2008:05:25:12][17018.3034266544][-sched:16-] Error: Ns_PgExec: result status: 7 message: ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^

[08/Feb/2008:05:25:12][17018.3034266544][-sched:16-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^
")

while executing
"ns_pg_bind select nsdb0 {
select notification_id,
notif_subject,
notif_text,
noti..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set result [list]
set selection [db_exec select $db $full_statement_name $sql]

while {[db_getro..."
(procedure "db_list_of_ns_sets" line 7)
invoked from within
"db_list_of_ns_sets select_notifications {}"
(procedure "notification::sweep::sweep_notifications" line 7)
invoked from within
"notification::sweep::sweep_notifications -interval_id 587 -batched_p 0"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 notification::sweep::sweep_notifications {-interval_id 587 -batched_p 0} 1202476992 0 f}"
[08/Feb/2008:05:26:11][17018.3034266544][-sched:12-] Error: Ns_PgExec: result status: 7 message: ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^

[08/Feb/2008:05:26:11][17018.3034266544][-sched:12-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^
")

while executing
"ns_pg_bind select nsdb0 {
select
message_id as id,
creation_date,
locking_server,..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]

set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_queued_messages {} {
# check if record is already there and free to use
set return_id [db_string get_qu..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"with_finally -code {
db_foreach get_queued_messages {} {
# check if record is already there and free to use
..."
(procedure "acs_mail_lite::sweeper" line 8)
invoked from within
"acs_mail_lite::sweeper"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 acs_mail_lite::sweeper {} 1202476990 0 f}"
[08/Feb/2008:05:26:12][17018.3034266544][-sched:16-] Error: Ns_PgExec: result status: 7 message: ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^

[08/Feb/2008:05:26:12][17018.3034266544][-sched:16-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^
")

while executing
"ns_pg_bind select nsdb0 {
select notification_id,
notif_subject,
notif_text,
noti..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set result [list]
set selection [db_exec select $db $full_statement_name $sql]

while {[db_getro..."
(procedure "db_list_of_ns_sets" line 7)
invoked from within
"db_list_of_ns_sets select_notifications {}"
(procedure "notification::sweep::sweep_notifications" line 7)
invoked from within
"notification::sweep::sweep_notifications -interval_id 587 -batched_p 0"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 notification::sweep::sweep_notifications {-interval_id 587 -batched_p 0} 1202476992 0 f}"
^X

Collapse
3: Re: import database (response to 1)
Posted by Claudio Pasolini on 02/09/08 09:15 AM
By default the 'createdb' command clones the 'template1' database and in your case it already contains several objects and functions.

Try: createdb -E UNICODE -T template0 openacs

Hope this helps.

Collapse
4: Re: import database (response to 3)
Posted by Iuri Sampaio on 02/11/08 01:06 AM
Thanks Claudio,
psql -f ran properly. Database importing succeed with no errors!

The key was to know the ltree's datamodel was related to template0 database

Furthermore, i guess not but, is that affect something on the openacs database?

best,

Collapse
5: Re: import database (response to 1)
Posted by Nima Mazloumi on 02/20/08 12:24 AM
One question: I have oacs installed in pg 8.1. later on i installed ltree and tsearch. now I want to upgrade to pg 8.2 but importing the dump results to errors:

Error: function »snb_ru_init« not found in »/usr/lib64/postgresql/tsearch2.so«
Error: function public.snb_ru_init(internal) does not exist
....
Error: function »snb_ru_init(internal)« does not exist
CONTEXT: COPY pg_ts_dict, Line 3, Column dict_init: »snb_ru_init(internal)«

Any idea on how to migrate between different pg versions and using latest ltree and tsearch stuff?