Nuxeo 5.5 and PostgreSQL 8.3

Florent_Guillau

Why is PostgreSQL 8.3 not supported anymore in Nuxeo 5.5?

Florent_Guillau

PostgreSQL 8.3 is not supported anymore for two reasons:

1. we have stored procedures that use a function (unnest) that was added in PostgreSQL 8.4.
2. the new fulltext prefixed search (foo*) works thanks to new features of the GIN index type that were introduced in PostgreSQL 8.4.

Although the first point could be worked around, the second cannot if you want to keep fulltext prefix search.

(Note also that PostgreSQL 8.3 is getting old and we can't see any compelling reason that would justify avoiding an upgrade to a more recent version of PostgreSQL — PostgreSQL 9.1 is worth it if only for performance reasons.)