Problem converting MSAccess database to Postgresql database

[bonak_shed]

Hi,

I am trying to convert my Poker Tracker Stud MS Access database to Postgresql and am getting an error at the end of the conversion process. The error
message reads:

Error creating index - game_level_idx_02

7 - SQLSTATE = 23505
ERROR: Could not create unique index "game_level_idx_02"
Table contains duplicate values.;
Error while executing the query

(See picture below)


Any idea what the problem could be?

J

[ptrack mike]

Go to the menu, Database Maintenance and Options. Select the Misc. tab. Are there any game levels listed that have the same game level description? If so what is the level and how many games are listed for each of the duplicate level descriptions?

[bonak_shed]

H MIke,

Yes I have some duplicates, they are as follows:

$0.25/$0.50/$0.05 (6 max) Hi/L total hands 1
$0.25/$0.50/$0.05 (6 max) Hi/L total hands 10
$0.25/$0.50/$0.05 (6 max) Hi/L total hands 9
$0.25/$0.50/$0.05 (6 max) Hi/L total hands 2
$0.25/$0.50/$0.05 (6 max) Hi/L total hands 1

J

[ptrack mike]

OK, do this:

1. Use Utilities > Export hand histories to File to make text files out of just those duplicate game levels.

2. Go to the Utilities > Maintenance and Options window. Stay on the first tab and sort the data section at the bottom by Limit. Then go to those duplicate $0.25/$0.50/$0.05 (6 max) Hi/L sessions. Select the sessions and Purge them.

3. Now go back the Misc. tab and remove all of those game limits since they should now each show 0 hands.

4. Convert your database to PostgreSQL.

5. After you start using the PostgreSQL database you can use File > Import Hand Histories to re-import the hands files you created in Step 1.

[bonak_shed]

Mike,

That worked. Many thanks for your prompt replies.

J