In the article the author suggests using a JPA named query - which is the query that hibernate is generating and is incorrect for postgres:
Here is the named query implementation for our needs:
select n from Node n left join fetch n.children

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira