Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Index problem.....
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 5005 of 5549
Post > Topic >>

Index problem...

by walterc@[EMAIL PROTECTED] (Carol Walter) May 22, 2008 at 12:41 PM

Greetings...

I'm getting an error.  The error says...

places=# REINDEX INDEX maps_map_id_seq;
ERROR:  "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR:  missing chunk number 0 for toast value 131343627

I have tried reindexing the index, the table, and the database.  I  
continue to get this error.  What can I do to recover from this.

Carol Walter

PS  Let me say that I know this is my fault.  This index is very  
bloated.  Yesterday, I tried to vacuum.   I got errors because  
max_fsm_pages what set at a number that was too small.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 5 Posts in Topic:
Index problem...
walterc@[EMAIL PROTECTED]  2008-05-22 12:41:54 
Re: Index problem...
HTomeh@[EMAIL PROTECTED]   2008-05-22 10:02:10 
Re: Index problem...
walterc@[EMAIL PROTECTED]  2008-05-22 13:37:56 
Re: Index problem...
walterc@[EMAIL PROTECTED]  2008-05-22 15:41:38 
Re: Index problem...
depesz@[EMAIL PROTECTED]   2008-05-22 22:15:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 17:05:26 CST 2008.