Postgresql setup for 9.x: if the CAST setup still required?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-02-2016 11:48 AM
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-03-2016 11:15 AM
I'm not sure. If you have feedback on this on an actual instance we could update the doc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-09-2016 07:00 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-31-2017 06:01 AM
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.
