cancel
Showing results for 
Search instead for 
Did you mean: 

Postgresql setup for 9.x: if the CAST setup still required?

otheus_uibk
Champ on-the-rise
Champ on-the-rise

The nuxeo documentation on postgresql says something about adding CAST functions to template0 before creating the database. As far as I can tell, with PG version 9.1.8 and later, these functions have a null effect -- the builtin casts already do this. Can someone please confirm for me that the documentation is in this regard, obsolete? https://doc.nuxeo.com/nxdoc/postgresql/

3 REPLIES 3

Florent_Guillau
World-Class Innovator
World-Class Innovator

I'm not sure. If you have feedback on this on an actual instance we could update the doc.

otheus_uibk
Champ on-the-rise
Champ on-the-rise

Well, so far, I have not seen the "invalid operator" exception in nuxeo logs, against pg 9.5 and nuxeo build 8.4. The special cast instructions were never followed.

Florent_Guillau
World-Class Innovator
World-Class Innovator

I can confirm that the casts are not needed anymore in recent Nuxeo versions. They're in the process of being removed from the documentation.

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.