X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C5208D1B37F; Fri, 25 Jun 2004 06:38:48 -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 92245-08; Fri, 25 Jun 2004 09:38:42 +0000 (GMT) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C08AD1B173; Fri, 25 Jun 2004 06:38:31 -0300 (ADT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id i5P9cMQT022249; Fri, 25 Jun 2004 13:38:22 +0400 (MSD) Date: Fri, 25 Jun 2004 13:38:22 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Achilleus Mantzios Cc: pgsql-general@postgresql.org, pgsql-bugs@postgresql.org Subject: Re: [GENERAL] tsearch2,pgsql 7.4.[1|2], pg_dump problem In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/148 X-Sequence-Number: 8572 Achilleus, we have regprocedure_7.4.patch.gz (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/) Oleg On Fri, 25 Jun 2004, Achilleus Mantzios wrote: > > Hi, i noticed a failure when i pg_dump/reload a database with tsearch2.sql > installed. > > I get ERRORS of the type: > > dynacom=# SELECT lexize('en_stem','foo bar'); > ERROR: cache lookup failed for function 4652394 > dynacom=# SELECT lexize('en_stem','foo bar'); > ERROR: cache lookup failed for function 4652394 > dynacom=# SELECT lexize('en_stem','foo bar'); > ERROR: cache lookup failed for function 4652394 > dynacom=# SELECT lexize('en_stem','foo bar'); > ERROR: cache lookup failed for function 4652394 > dynacom=# > dynacom=# SELECT to_tsvector('default','foo bar'); > ERROR: cache lookup failed for function 4652424 > dynacom=# SELECT to_tsvector('default','foo bar'); > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Failed. > !> > !> > !> \q > > Always the 1st call in a session to to_tsvector gives: > ERROR: cache lookup failed for function 4652424 > and the very next call in the same session causes the postmaster > to SEGV. > > This situation is demonstrated in FreeBSD 5.1-RELEASE-p10, pgsql 7.4.1 > and in Debian 2.4.18-bf2.4, pgsql 7.4.2. > > A workaround is to first load tsearch2.sql script in the newly created > database, reload the dump, and ignore any tsearch2 subsequent ERRORS. > > Anyone has a clue? > > 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