X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2BDEBD1EBEF for ; Tue, 23 Mar 2004 13:50:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57247-09 for ; Tue, 23 Mar 2004 09:50:34 -0400 (AST) Received: from mailengine2.web2000.activeisp.com (webmail2.activeisp.com [213.188.134.18]) by svr1.postgresql.org (Postfix) with ESMTP id E93C9D1E9C7 for ; Tue, 23 Mar 2004 09:50:29 -0400 (AST) Received: from ELAPTOP (unverified [81.97.165.178]) by webmail.activeisp.com (Rockliffe SMTPRA 5.3.6) with ESMTP id for ; Tue, 23 Mar 2004 14:50:55 +0100 From: "Mike Bell" To: Subject: Cache loolup failed problems with tsearch following pg_restore Date: Tue, 23 Mar 2004 13:47:52 -0000 Organization: hashdefine ltd Message-ID: <01ce01c410dd$703ba370$6401a8c0@hashdefine.local> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/296 X-Sequence-Number: 12865 Hi, I'm am having real problems restoring a database which uses tsearch2. I've followed the dump/restore notes in the tseach2 documents. After much fiddling, I have managed to restore the database. However, as soon as I call a SP which updates a table which uses ts_vector. I get the following error: 2004-03-23 11:53:03 [27000] ERROR: fmgr_info: function 534990: cache lookup failed The following is from the pg errorlog: 2004-03-23 11:53:03 [27000] LOG: query: INSERT INTO article_content ( active , article_id , lang_id , active_date , expire_date , revision_date , revision_days , content_type_id , contribution_receipt_date , version , article_type_id , override_template_id , name , copyright , summary , comment , content , search1 ) VALUES ( true , $1 , $2 , $3 , $4 , $5 , $6 ::interval , $7 , $8 , DEFAULT , $9 , $10 , $11 , $12 , $13 , $14 , $15 , to_tsvector('default', coalesce( $16 ,'') || ' ' || coalesce( $17 ,'') || ' ' || coalesce(strip_tags( $18 ),'')) ) 2004-03-23 11:53:03 [27000] LOG: query: select oid from pg_ts_cfg where ts_name = $1 2004-03-23 11:53:03 [27000] LOG: query: select prs_name from pg_ts_cfg where oid = $1 2004-03-23 11:53:03 [27000] LOG: query: select lt.tokid, pg_ts_cfgmap.dict_name from pg_ts_cfgmap, pg_ts_cfg, token_type( $1 ) as lt where lt.alias = pg_ts_cfgmap.tok_alias and pg_ts_cfgmap.ts_name = pg_ts_cfg.ts_name and pg_ts_cfg.oid= $2 order by lt.tokid desc; 2004-03-23 11:53:03 [27000] LOG: query: select oid from pg_ts_parser where prs_name = $1 2004-03-23 11:53:03 [27000] LOG: query: select prs_start, prs_nexttoken, prs_end, prs_lextype, prs_headline from pg_ts_parser where oid = $1 2004-03-23 11:53:03 [27000] ERROR: fmgr_info: function 534990: cache lookup failed PostgreSQL 7.3.3 on i386-redhat-linux-gnu, compiled by GCC 2.96 I'm totallly stuck - I have seen pg postings which refer to droping and re-creating SPs but I don't have the knowledge of tseach2 to understand all the dependencies. Hope someone can help!! Cheers Mike -- Dr Mike Bell 07973 524 446