index problem - Mailing list pgsql-general

hi!


I created an index using pgaccess rescently. the name of the index was
long:

"oceny_stud_numer_albumu_protokoloceny_stud"

now i am unable to vacuum my database. i obtain something like this when
i try:

NOTICE:  Pages 310: Changed 0, reaped 2, Empty 0, New 0; Tup 48611: Vac 3,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 48, MaxLen
48; Re-using: Free/Avail. Space 3096/116; EndEmpty/Avail. Pages 0/1. CPU
0.02s/0.01u sec.
pqReadData() -- backend closed the channel unexpectedly.
    This probably means the backend terminated abnormally
    before or while processing the request.
connection to server was lost
vacuumdb: vacuum failed

pg_dump works, so i am able to backup my db and to restore it under
another name.

i tryed to delete my index:

nat=# drop index oceny_stud_numer_albumu_protokoloceny_stud;
NOTICE:  identifier "oceny_stud_numer_albumu_protokoloceny_stud" will be
truncated to "oceny_stud_numer_albumu_protoko"
ERROR:  index "oceny_stud_numer_albumu_protoko" nonexistent

then i did:

nat=# select * from pg_class where
relname='oceny_stud_numer_albumu_protoko';
 relname | reltype | relowner | relam | relpages | reltuples |
rellongrelid | relhasindex | relisshared | relkind | relnatts | relchecks
| reltriggers | relukeys | relfkeys | relrefs | relhaspkey | relhasrules |
relacl

---------+---------+----------+-------+----------+-----------+--------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+-------------+--------
(0 rows)

however:

nat=# select * from pg_class where
relname~'oceny_stud_numer_albumu_protoko';
               relname               | reltype | relowner | relam |
relpages | reltuples | rellongrelid | relhasindex | relisshared | relkind
| relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs |
relhaspkey | relhasrules | relacl

-------------------------------------+---------+----------+-------+----------+-----------+--------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+-------------+--------
 oceny_stud_numer_albumu_protokol_id | 6580575 |       32 |   403 |
122 |     48611 |            0 | f           | f           | i       |
2 |         0 |           0 |        0 |        0 |       0 | f          |
f           | (1 row)


then i tryed:

nat=# drop index oceny_stud_numer_albumu_protokol_id;
NOTICE:  identifier "oceny_stud_numer_albumu_protokol_id" will be
truncated to "oceny_stud_numer_albumu_protoko"
ERROR:  index "oceny_stud_numer_albumu_protoko" nonexistent


my question is:
~~~~~~~~~~~~~~~
how may i delete this index in my original database???


thanks for any help..

marcin inkielman