PostgreSQL 8.4 does not handle well negative integer comparisons

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 5.2.3, 6.0.5 GA
• Fix Version/s: --Sprint - SP, 6.0.6 GA, 6.1.0 CE RC1
• Component/s: Environments > Databases, Message Boards
• Labels: None
• Environment: Postgresql 8.4
• Branch Version/s:
  6.0.x, 5.2.x
• Backported to Branch:
  Committed

When trying to publish a MB message, portlet becomes temporarily unavailable and log shows:

11:20:04,109 ERROR [JDBCExceptionReporter:234] ERROR: operator does not exist: bigint !=- integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type cast
Position: 144
11:20:04,288 ERROR [render_portlet_jsp:154] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:190)
at com.liferay.portlet.messageboards.service.persistence.MBMessagePersistenceImpl.countByG_U(MBMessagePersistenceImpl.java:9750)
at com.liferay.portlet.messageboards.service.impl.MBStatsUserLocalServiceImpl.updateStatsUser(MBStatsUserLocalServiceImpl.java:133)
.....