Forum OpenACS Development: PostgreSQL 9.x Incompatibilities in OACS 5.9?
We were looking into a ]project-open[ errors on OpenACS 5.9, which was cause by a select of "nextval" from one of these sequence views frequently used in OpenACS. We fixed it very quickly.
We then started a "find" for ".nextval" in all of OpenACS and found a number of occurrences. I understand that all of these occurrences wil produce errors in PG 9.x. Maybe the occurrences are irrelevant? I've tried to classify them below.
"Actual Issues" (I believe):
Issues in deprecated packages(?)
Issues in outdated XoWiki Version(?)
Issues in the documentation
It looks like you grepped through the source and grouped the results, rather than errors that block you. I've checked most of the files above. Some places are uncalled functions, the *postgresql-postgresq.xql* is already removed since a few weeks, a few issues are in non-maintained packages not in the oacs-5-9 (events), xotcl-core-po is unknown for me, xotcl-core is a false positive, .. and yes, the docs should be update (Are there vounteers?)
Below is a discussion from a few years ago:
In case, there are real issue, a bug-tracker entry would be appreciated.