Scot, PostgreSQL 8.2 works well with RT. There was a post or two to the mailing list that had some needed tuning suggestions. Also, be sure to add my patch to DBIx/SearchBuilder/Handle/Pg.m to make the Tickets query builder usable. I posted it to rt-users but it has not been incorporated in DBIx::SearchBuilder as of the 1.48 release. Here is the change needed:
diff Pg.pm Pg.pm_ORIG 238c238 < $$statementref = "SELECT main.* FROM ( SELECT DISTINCT main.id FROM $$statementref ) distinctquery, $table main WHERE (main.id = distinctquery.id) "; --- > $$statementref = "SELECT DISTINCT main.* FROM $$statementref"; Also, dump the OID columns when you move to 8.2. If you have any questions, let me know. Ken On Fri, Mar 16, 2007 at 02:42:58PM -0500, Scott Kronenfeld wrote: > Does anyone have any experience using RT w/ postgres 8.2? We are > upgrading postgres from v7.4. Any comments or pointers would be > welcome. Unfortunately, I have not had any hits on the mailing list > archives. > > Thanks, > Scot _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
