topic Postgresql setup for 9.x: if the CAST setup still required? in Nuxeo Forum

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

otheus_uibk — Wed, 02 Nov 2016 15:48:35 GMT

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/

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

Florent_Guillau — Thu, 03 Nov 2016 15:15:31 GMT

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

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

otheus_uibk — Wed, 09 Nov 2016 12:00:48 GMT

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.

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

Florent_Guillau — Tue, 31 Jan 2017 11:01:08 GMT

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.