Conversion error

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Conversion error

Postby spam » Thu May 22, 2008 5:16 am

I've seen questions about this error in other posts but haven't been able to find a working solution posted yet. If the question already have been answered I apologize.

While converting my PT2 DB to Postgres I get tghe following error:

Error creating index - game_players_idx_01

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

Any help is appreciated!
spam
 
Posts: 5
Joined: Thu Mar 06, 2008 6:21 am

Re: Conversion error

Postby ptrack pat » Thu May 22, 2008 8:01 am

Open the File > Maintain Database Names window and double-click on the database name field for this "ptrack" entry. What is the size and file name that shows in the window that opens?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Conversion error

Postby spam » Thu May 22, 2008 9:24 am

ptrack2.mdb

size: 208,441KB
spam
 
Posts: 5
Joined: Thu Mar 06, 2008 6:21 am

Re: Conversion error

Postby ptrack pat » Thu May 22, 2008 12:41 pm

Since the db isn't really that big, the easiest thing to do would be to use the Utilities > Export Hand Histories To File option to export all you hands to text files and then import those files into PT3.

If that doesn't work for you, let me know and I'll give you something else to try.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Conversion error

Postby spam » Thu May 22, 2008 2:10 pm

Oh, sorry if I wasn't clear, I never intended on converting it to PT3 just to run PT2 with Postgres instead of Access.

However I guess I could export all HH's anyway and convet a new empty DB to Postgres and then import everything..... I'll try that and see if that works.
spam
 
Posts: 5
Joined: Thu Mar 06, 2008 6:21 am


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests