[
https://jira.nuxeo.com/browse/NXP-7902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=108113#comment-108113
]
Bruce Grant commented on NXP-7902:
----------------------------------
Does this mean that Postgresql 8.4 is de rigeur for Nuxeo 5.5?
> pathOptimizations does not work on PostgreSQL 8.3 (no unnest function)
> ----------------------------------------------------------------------
>
> Key: NXP-7902
> URL: https://jira.nuxeo.com/browse/NXP-7902
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.5
> Environment: PostgreSQL 8.3
> Reporter: Benoit Delbosc
>
> The unnest method exists only in PostgreSQL 8.4, the NX_ANCESTORS function
> use it and raises the following error:
> {code}
> Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
> org.postgresql.util.PSQLException. message: ERREUR: la fonction
> unnest(character varying[]) n'existe pas
> Hint: Aucune fonction ne correspond au nom donné et aux types d'arguments.
> Vous devez ajouter des conversions explicites de type.
> Where: PL/pgSQL function "nx_ancestors" line 5 at FOR over SELECT rows
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
> at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
> at $Proxy30.executeQuery(Unknown Source)
> at
> org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.getAncestorsIds(JDBCMapper.java:819)
> ... 148 more
> {code}
> This prevent Nuxeo to start.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
