Postgres Pro
Downloads
Home   >   mailing lists

HINT: Please REINDEX it? - Mailing list pgsql-general

From Bjørn T Johansen
Subject HINT: Please REINDEX it?
Date
Msg-id 20090326090053.26bb29f3@btj-laptop.asp-as.no
Whole thread Raw
Responses Re: HINT: Please REINDEX it?  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Tree view 
I am seeing this in my log...:

ERROR:  index "connect_idx" contains unexpected zero page at block 208
HINT:  Please REINDEX it.


What does this mean? And how do I reindex it?



Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Question about hosting and server grade
Next
From: "Albe Laurenz"
Date:
Subject: Re: [ADMIN] Can we load all database objects in memory?