Index: openacs-4/packages/acs-admin/www/apm/version-view-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/version-view-postgresql.xql,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-admin/www/apm/version-view-postgresql.xql 25 Sep 2017 17:47:11 -0000 1.2 +++ openacs-4/packages/acs-admin/www/apm/version-view-postgresql.xql 10 May 2021 09:23:56 -0000 1.2.2.1 @@ -11,22 +11,19 @@ from apm_package_versions where package_key = :package_key and installed_p = 't' - limit 1 + fetch first 1 rows only - select data_model_installed_version from ( select version_name as data_model_installed_version from apm_package_versions where package_key = :package_key and data_model_loaded_p = 't' order by apm_package_version__sortable_version_name(version_name) desc - ) as bad_postgres_needs_this - limit 1 - + fetch first 1 rows only