Can't drop a table ...

Hello,

As a followup of my mail from yesterday, I am trying to export the second
database and I have some problems with a table called "foo". The developer
is telling me that I can drop that table so I try and I get this error:

testivo=# drop table foo;
FATAL 2:  open of /usr/local/pgsql/data/pg_clog/0773 failed: No such file
or directory
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.
!#

The strange thing is that this file is present...:

# ls -la 0773
-rw-------    1 postgres postgres    98304 May 15 11:14 0773
# pwd
/usr/local/pgsql/data/pg_clog

When I try to do a "pg_dump -C -f dump.sql testivo"

I get this error after an export of 600MB so far...

pg_dump: dumping out the contents of table foo
pg_dump: ERROR:  stat failed on file '/usr/lib/pgsql/tsearch': No such
file or directory
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "foo" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR:  stat failed on file
'/usr/lib/pgsql/tsearch': No such file or directory
pg_dump: The command was: COPY "foo" TO stdout;
pg_dump: *** aborted because of error

Would the recommendation be to install "tsearch"?

/B

--

--- Bruno Mattarollo <bruno@web1.greenpeace.org> ---
    SysAdmin & TechLead - Greenpeace International
    http://www.greenpeace.org/
----------------------------------------------------