Database conversion error
Posted: Tue Aug 12, 2008 4:49 am
Hello - I'm getting an error when I try to convert my pokerstars (about 50,000 hands) access database to SQL. I've installed PostgreSQL vers. 8.3 and successfully converted a (smaller) Party database with no problem. The problem happens late in the conversion process when it is creating indexes with the error message:
Error creating index - game_players_idx_01
7 - SQLSTATE = 235050 ERROR: could not create unique index
Table contains duplicated values; Error while executing the query.
FYI PT version is 2.17.02 & I'm running windows on a Parallel's virtual machine on a Mac.
Thanks in advance Pat / all for help on this matter.
Richard C
Error creating index - game_players_idx_01
7 - SQLSTATE = 235050 ERROR: could not create unique index
Table contains duplicated values; Error while executing the query.
FYI PT version is 2.17.02 & I'm running windows on a Parallel's virtual machine on a Mac.
Thanks in advance Pat / all for help on this matter.
Richard C