pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mike Bell <mike.bell@hashdefine.co.uk>
To: pgsql-admin@postgresql.org
Subject: Cache loolup failed problems with tsearch following pg_restore
Date: Tue, 23 Mar 2004 13:47:52 -0000
Message-ID: <01ce01c410dd$703ba370$6401a8c0@hashdefine.local> (raw)

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





view thread (4+ messages)  latest in thread

Message-ID: <01ce01c410dd$703ba370$6401a8c0@hashdefine.local>
Permalink:  ../01ce01c410dd$703ba370$6401a8c0@hashdefine.local/
Also on:    postgresql.org/message-id/01ce01c410dd$703ba370$6401a8c0@hashdefine.local

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: mike.bell@hashdefine.co.uk
  Subject: Re: Cache loolup failed problems with tsearch following pg_restore
  In-Reply-To: <01ce01c410dd$703ba370$6401a8c0@hashdefine.local>
  References: <01ce01c410dd$703ba370$6401a8c0@hashdefine.local>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox