pokerstrat
09-05-2008, 05:28 AM
I'm importing hands and see this:
the following error occurred when running this report:Error:xx002:index"playerhandscashkeycolumns_hero_idx1'' is not a btree.
And this is not working-
"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 “DROP INDEX playerhandscashkeycolumns_idx1” without the quotes and press F5 to run it. It should finish quickly
6) Then type "CREATE INDEX "playerhandscashkeycolumns_idx1" ON playerhandscashkeycolumns USING btree (player_id,handtimestamp);" again with no outside quotes and press F5"
Please help me!
the following error occurred when running this report:Error:xx002:index"playerhandscashkeycolumns_hero_idx1'' is not a btree.
And this is not working-
"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 “DROP INDEX playerhandscashkeycolumns_idx1” without the quotes and press F5 to run it. It should finish quickly
6) Then type "CREATE INDEX "playerhandscashkeycolumns_idx1" ON playerhandscashkeycolumns USING btree (player_id,handtimestamp);" again with no outside quotes and press F5"
Please help me!