From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | tsearch2,pgsql 7.4.[1|2], pg_dump problem |
Date: | 2004-06-25 06:08:13 |
Message-ID: | Pine.LNX.4.44.0406250859340.8529-100000@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general pgsql-sql |
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?
--
-Achilleus
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2004-06-25 09:38:22 | Re: [GENERAL] tsearch2,pgsql 7.4.[1|2], pg_dump problem |
Previous Message | Sam | 2004-06-25 04:44:33 | two bugs in 'initdb' |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-06-25 08:46:43 | Re: Endless For Loop in an insert trigger |
Previous Message | Tom Lane | 2004-06-25 05:18:25 | Re: Deadlock. Referential Integrity checks select for update? |
From | Date | Subject | |
---|---|---|---|
Next Message | sad | 2004-06-25 06:20:41 | Re: feature request ? |
Previous Message | Rosser Schwarz | 2004-06-25 05:37:45 | Re: feature request ? |