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):
- ./acs-kernel/sql/postgresql/utilities-create.sql
- ./acs-tcl/tcl/00-database-procs-postgresql-postgresql.xql
- ./acs-tcl/tcl/00-database-procs.tcl

Issues in deprecated packages(?)
- ./chat/sql/postgresql/chat-create.sql
- ./events/www/admin/event-price-ae.tcl
- ./events/www/admin/spam/action-choose.tcl

Issues in outdated XoWiki Version(?)
- ./xotcl-core-po/tcl/05-db-procs.tcl
- ./xotcl-core/tcl/05-db-procs.tcl

Issues in the documentation
- ./acs-content-repository/www/doc/tutorial.adp
- ./acs-core-docs/www/db-api-detailed.adp
- ./acs-core-docs/www/db-api.adp
- ./acs-core-docs/www/files/acceptance-sql.txt
- ./acs-core-docs/www/xml/developers-guide/db-api.xml
- ./acs-core-docs/www/xml/files/acceptance-sql.txt
- ./acs-core-docs/www/xml/kernel/db-api.xml
- ./acs-templating/www/doc/guide/forms.adp
- ./acs-templating/www/doc/guide/wizards.adp
- ./acs-tcl/tcl/form-processing-procs.tcl

Posted by Gustaf Neumann on
Hi Frank,

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.