index problem

From: Marcin Inkielman <marn(at)wsisiz(dot)edu(dot)pl>
To: postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: index problem
Date: 2000-06-01 20:01:13
Message-ID: Pine.LNX.4.21.0006012141350.12410-100000@mi.marnnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Lynde 2000-06-01 20:09:47 Re: Postmaster won't -HUP
Previous Message Bruce Momjian 2000-06-01 19:39:28 Re: shared memory