https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-5-and-postgresql-8-3/m-p/324020#M11021 <P>You must have gotten this question a lot to post and answer your own question in 4 minutes</P> Mon, 16 Dec 2013 15:52:00 GMT ben-Nabiy_Derus 2013-12-16T15:52:00Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-5-and-postgresql-8-3/m-p/324018#M11019 <P>Why is PostgreSQL 8.3 not supported anymore in Nuxeo 5.5?</P> Wed, 21 Dec 2011 15:41:03 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-5-and-postgresql-8-3/m-p/324018#M11019 Florent_Guillau 2011-12-21T15:41:03Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-5-and-postgresql-8-3/m-p/324019#M11020 <P>PostgreSQL 8.3 is not supported anymore for two reasons:</P> <OL> <LI>we have stored procedures that use a function (<CODE>unnest</CODE>) that was added in PostgreSQL 8.4.</LI> <LI>the new fulltext prefixed search (<CODE>foo*</CODE>) works thanks to new features of the GIN index type that were introduced in PostgreSQL 8.4.</LI> </OL> <P>Although the first point could be worked around, the second cannot if you want to keep fulltext prefix search.</P> <P>(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.)</P> Wed, 21 Dec 2011 15:45:29 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-5-and-postgresql-8-3/m-p/324019#M11020 Florent_Guillau 2011-12-21T15:45:29Z https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-5-and-postgresql-8-3/m-p/324020#M11021 <P>You must have gotten this question a lot to post and answer your own question in 4 minutes</P> Mon, 16 Dec 2013 15:52:00 GMT https://connect.hyland.com/t5/nuxeo-forum/nuxeo-5-5-and-postgresql-8-3/m-p/324020#M11021 ben-Nabiy_Derus 2013-12-16T15:52:00Z