[rt-users] Upgrade Your Postgresql!

[Jesse Vincent]

In fact, I discovered recently that Postgres versions before 7.1 did not
support one of the join types that RT needs. Expect 2.0.9 to note the hard
requirement for 7.1. Oh. wait. I already do. :) Better make sure that's true
everywhere.




On Tue, Oct 02, 2001 at 07:26:50AM -0500, Michael Huttinger wrote:
> Hello Everyone,
> 
> I am posting this to let you all know about a problem I was having and the
> solution.
> 
> Problem:
> 
> Running 2.0.8pre3 (from CVS) or 2.0.7 of RT, using Postgresql (7.0 series),
> and are having problems with a bug submitted not showing up in the user's
> home page top 25 requested list.
> 
> As a side note, whenever I add the requestor to a query, I get NO results,
> even if I can see in the list the requestor I want.  For example, I select
> to see all new items in a queue.  Looking at the list, a choose a requestor
> from the Requestor(s) column and add an additional query for it (using
> either is or contains).  I no longer get anything :(
> 
> Solution:
> 
> After some log scans and responses w/ Jesse, came to the conclusion this was
> due to the handling of outer joins in the SQL passed to Postgresql.  By
> upgrading to the 7.1 series of Postgresql (7.1.3 actually), the problem went
> away (7.1 has changed the way it handles the syntax for outer joins).
> 
> So, if you're running postgres prior to 7.1, I would recommend an upgrade :)
> 
> Enjoy!
> 
> Michael Huttinger
> Computer Engineer
> IPACT
> web:  http://www.ipact.com
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.