by sdlsdlsd » Sat Sep 25, 2010 10:37 pm
> Try using the PostgreSQL Database Functions in the Utilities menu. I don't currenly have PT2 set up with PostgreSQL but the housekeeping functions may help.
I tried a Vacuum Full/Analyze and the problem remains.
> What version of PostgreSQL do you have?
8.4
> Is everything else working OK?
Usually yes, altho today i've come across another problem, importing hands late in the Pokerstars 100k VIP Monthly tourney. I think it might be unrelated, my very rough guess is perhaps the blind level name 'XXVIII' exceeds the maximum size PT expects?:
*********************************
PT Version: 2.17.04m
Error Date: 09/25/2010 16:04
Database Error: 7
Error Text: SQLSTATE = 22001
ERROR: value too long for type character varying(5);
Error while executing the query
No changes made to database.
INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 128, 13682, 13682, {ts '2010-09-25 19:04:13'}, 17, 'XXVIII', 0, 14000.0000, 129680, {ts '2010-09-25 16:04:58'}, '305278298 620', '(did not show hand)', 129680, 0, 8, 0, '50170060110' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 128, 13682, 13682, {ts '2010-09-25 19:04:13'}, 17, 'XXVIII', 0, 14000.0000, 129680, {ts '2010-09-25 16:04:58'}, '305278298 620', '(did not show hand)', 129680, 0, 8, 0, '50170060110' )
*********************************