I am trying to run Xwiki with Postgresql 8.1 (jdbc3 driver) and Tomcat 5.5
on a Linux (Debian unstable) system.
I loaded up the xwiki-pgdb.tgz files and they ran through psql correctly.
I then started tomcat, and in the log found complaints about some of the
fields being set from boolean expressions. PG 8.1 is much fussier about
the right data going into the right field type than older releases.
The following field in the following tables needed to be changed from
INT(2) to boolean, and the corresponding initialisation values in the
startup data changed from 0 and 1 to true and false.
Table Column
xwikiclassesprop xwp_unmodifiable
xwikidblistclasses xwl_multiselect
xwikidblistclasses xwl_relational
xwikislistclasses xwl_multiselect
xwikislistclasses xwl_relational
If anyone wants revised versions of these files with all the changes
made I am happy to send them, but as one of them is over 1MB I think
that attaching them to this email would be wrong - even if compresses.
David