Primary key Index Error

From: Manoj K P <manoj(at)comodo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Primary key Index Error
Date: 2011-10-24 08:22:43
Message-ID: 1319444563973-4931714.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres recovered from data folder , after that some queries shows error

select * from table2 order by app_id ; - its work ( 50000000 data)
select * from table2 order by app_id desc ; - its work

Here app_id contains binary index

select * from table2 order by id ; - its work ( 50000000 data)
select * from table2 order by id desc ; - shows following error

manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero
page at block 311121
manoj [local] postgres HINT: Please REINDEX it.

index "tbl2_id_pkey" is primary key

Reindex not pratical this table (250 GB data)

How i can solve this ?

Regards
Manoj K P

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Primary-key-Index-Error-tp4931714p4931714.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edoardo Panfili 2011-10-24 08:30:06 Re: PostGIS in a commercial project
Previous Message Pavel Stehule 2011-10-24 08:03:46 Re: PostGIS in a commercial project