I remember there was a module that show the category tree just above the node title.

Home >> Mammals >> Dogs >> Chiwawa

I tried it, doesn't work with pgsql, fixed, submitted the patch, but still doesn't look as what I'm looking for.

Well the description says:

...displaying the title and description of the current term, a "breadcrumb" trail of the current taxonomy term and any parent terms, and titles and descriptions of any sub-terms of the current term (similar in format to the listing of nodes in a term)...

But I can't get it.