PDA

View Full Version : Error "handhistories_pkey" is not a btree", How I Reindex ?



dragonrib
11-05-2008, 07:42 AM
Hi, Im not able to see the hands I play yesterday and when i tried to purge some hands i receive the error :

"handhistories_pkey" is not a btree"

I believe I should recreate this index in order to solve my problem.

How can i do this ? Could you help me please ?

Thanks and brds

dragonrib
11-05-2008, 10:32 AM
I found this tip but dont know if can use it to solve my problem :

"It looks like your db has become partially corrupted

You can fix it by doing this:

1) Open pgadmin from your start menu in windows under postgresql
2) Double click on the server name and enter your postgresql password (default is postgrespass)
3) Click on Databases and select the current database
4) Click on the Icon at the top that has the SQL and pencil
5) Type

alter table handhistories drop constraint handhistories_pkey

and press F5 to run it. Then, when it is done, replace it with the line below and hit F5 again

alter table handhistories add constraint handhistories_pkey PRIMARY KEY (pokerhand_id)

After doing this launch Holdem Manager and try importing some new hands. It should work after this and you should be able to export as well.

Thanks,

Roy"

??

morny
11-05-2008, 06:08 PM
Update to this version which has a built in tool for rebuilding indexes: http://www.holdemmanager.com/downloads/HmUpdate1.06.04beta.exe

And then follow this FAQ: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168