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