X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 005D25359B for ; Tue, 26 Apr 2005 17:57:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15254-10 for ; Tue, 26 Apr 2005 20:57:33 +0000 (GMT) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id 57279540C2 for ; Tue, 26 Apr 2005 17:57:25 -0300 (ADT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.13.4/8.13.4) with ESMTP id j3QKvDLn002645; Wed, 27 Apr 2005 00:57:13 +0400 (MSD) Date: Wed, 27 Apr 2005 00:57:13 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Mario Soto Cordones Cc: pgsql-admin@postgresql.org, Alvaro Herrera Subject: Re: cache lookup failed for function 8044889 In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.894 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SUBJ_HAS_UNIQ_ID X-Spam-Level: X-Archive-Number: 200504/374 X-Sequence-Number: 17387 On Tue, 26 Apr 2005, Mario Soto Cordones wrote: > Hi > I migrate the database according to the procedure indicated in the > documentation of 8.0.2 , but I have not read the documentation of the > patch of the tsearch, but my others functions make in pl/pgsql make so you have two choices - if you have 7.4.5 still available then read docs and try patch and you should get good dump, or reinstall tsearch2 stuff. There are OIDs stored in tsearch2 config tables > for me work fine > > thank > > > 2005/4/26, Oleg Bartunov : >> How did you migrate to 8.0 ? >> Have you read about regprocedure patch from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ? >> >> Oleg >> On Tue, 26 Apr 2005, Mario Soto Cordones wrote: >> >>> Hello list, there is migrate to postgreSQL 8.0. and I have begun to have >>> some errors, before had the 7.4.5: >>> For example I have the following function: >>> >>> CREATE OR REPLACE FUNCTION "public"."find_observaciones_activos" >>> (integer, integer, text) RETURNS SETOF "public"."finddoc_t" AS >>> $body$ >>> select set_curcfg('default'); >>> select co_empresa, co_filial, nu_activo_fijo,sq_serialcolumn, >>> headline(tx_observaciones, q), >>> rank(vector, q) >>> from observaciones_activos, to_tsquery($3) as q >>> where co_empresa = $1 and co_filial = $2 and >>> vector @@ q order by rank(vector,q) desc >>> $body$ >>> LANGUAGE 'sql' STABLE CALLED ON NULL INPUT SECURITY INVOKER; >>> >>> and to execute this say >>> >>> cache lookup failed for function 8044889 >>> >>> CONTEXT: sentencia SQL: ??select lt.tokid, map.dict_name from >>> public.pg_ts_cfgmap as map, public.pg_ts_cfg as cfg, >>> public.token_type( $1 ) as lt where lt.alias = map.tok_alias and >>> map.ts_name = cfg.ts_name and cfg.oid= $2 order by lt.tokid desc;?? >>> funci??n SQL ??find_observaciones_activos?? en la sentencia 1 >>> >>> >>> i drop all functions and I have recreated them again, but the problem >>> persist, but with the 7.4.5 version all work fine... only functions >>> alone the functions related with ltree or tsearch or spatial >>> implementation don't work >>> >>> any idea please ????? >>> >>> >>> >> >> Regards, >> Oleg >> _____________________________________________________________ >> Oleg Bartunov, sci.researcher, hostmaster of AstroNet, >> Sternberg Astronomical Institute, Moscow University (Russia) >> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ >> phone: +007(095)939-16-83, +007(095)939-23-83 >> > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83