PivotTable is using database specific SQL

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Configure ActivityInfo in order to use a PostgreSQL database
2. Go to the "tables" page
3. Select any indicator
4. Click "Refresh Preview"


What is the expected output? What do you see instead?

A table featuring the selected indicators should be displayed.
Instead a popup state that an error occured.

Server-side, the following error is logged:
org.hibernate.exception.SQLGrammarException: error executing work
[...]

Caused by: org.postgresql.util.PSQLException: ERREUR: l'opérateur n'existe pas 
: boolean = integer
  Indice : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
  Position : 654
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
        at org.sigmah.server.dao.hibernate.PivotHibernateDAO$1.execute(PivotHibernateDAO.java:459)
        at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1873)
        ... 88 more

Original issue reported on code.google.com by [email protected] on 5 Oct 2010 at 10:11