PDA

View Full Version : New version postgresql Import Error



Yersh
10-11-2008, 11:31 AM
I installed postgres 8.3.4. And found that it doesn't import some hands. When I looked through import logs, there were lines like this one:
C:\3\1179183001.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

when I tried to import the same files another time, it imported 1 or 2 but still returnes errors for the most part of them

BTW, the same DB on postgres 8.2.7 with the same configuration imports all these files without any errors.

PS. The DB timeout error with purging large amounts of hands (more than 200k) is still havn't solved :(

morny
10-11-2008, 01:37 PM
Can you try a new database and see if the problem persits. http://208.109.95.123/faq/afmviewfaq.aspx?faqid=146

Improvements with purging have been made in this beta http://www.holdemmanager.com/downloads/HmUpdate1.06.04beta.exe

Yersh
10-11-2008, 02:54 PM
Yes, with new empty DB it's ok.
Then I just have to remember that's the safest way to upgrade db is to export and reimport all hands, not to backup/restore through pgadmin. :)