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
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 |