hi all,
i use [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2] on a
linux mandrake 7.0
after i have drop some tables and index i don't use, i c'ant do a vacuum on the
database.
here is the error :
[me@www me]$ psql mydb -u
Username: postgres
Password:
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: mydb
mydb=> vacuum ;
NOTICE: Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1021) IS NOT THE SAME AS
HEAP' (1022)
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible.
Terminating.
[me@www me]$
...
mydb=> \d pg_proc_prosrc_index
Table = pg_proc_prosrc_index
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| prosrc | text | var |
+----------------------------------+----------------------------------+-------+
mydb=>
what should i do now ?
is my database corrupt ?
any idea ?
thanks for any help !
ANGE
--
******************************************************************************
POZZO Ange Michel
mail : [EMAIL PROTECTED]
Administrateur - Développeur
ALPINFO
617 Rue Denis Papin
73290 La Motte Servolex
Savoie - France
tel : 04 79 26 06 28
fax : 04 79 25 68 36
Zonecommerce, l'annuaire français du commerce électronique
- Plusieurs centaines de magasins référencés pour tous vos achats
sur internet, tous avec paiements sécurisés en ligne
- Des promotions proposées par les boutiques
- Vente aux enchères, forum de discussion
- Des actualités, sports et loisirs, cinéma, horoscope ...
- Les iddées d'olivia, le site du mois, l'interview
- Des liens, des conseils ...
http://www.zonecommerce.com/
******************************************************************************
