Project:
| View Revisions: Issue #39332 | [ Back to Issue ] | ||
| Summary | 0039332: PG 11: ad_db_modified function fails | ||
| Revision | 2018-09-21 08:21 by caristu | ||
| Description | The ad_db_modified fails in PostgreSQL11, because it is using a query[1] that makes use of the proisagg column which does not longer exists in the pg_proc catalog table. Note that the function is failing silently because on case of error, the exception is caught and 'N' is returned. [1] https://code.openbravo.com/erp/devel/pi/file/tip/src-db/database/model/prescript-PostgreSql.sql#l1341 [^] |
||
| Revision | 2018-09-21 08:17 by caristu | ||
| Description | The ad_db_modified fails in PostgreSQL11, because it is using a query[1] that makes use of the proisagg column which does not longer exists in the pg_proc catalog table. The function si failing silently because on case of error, the exception is caught and 'N' is returned. [1] https://code.openbravo.com/erp/devel/pi/file/tip/src-db/database/model/prescript-PostgreSql.sql#l1341 [^] |
||
| Revision | 2018-09-21 08:17 by caristu | ||
| Steps To Reproduce | Using PostgreSQL 11: 1. Apply the attached patch (just for testing) that raises an exception in case an error happens during the execution of the ad_db_modified function. 2. Run ant install.source. It fails: database.postcreate.POSTGRE: [sql] Executing commands [sql] Failed to execute: SELECT AD_DB_MODIFIED('Y') BUILD FAILED /home/openbravo/src/openbravo/pi/build.xml:686: The following error occurred while executing this line: /home/openbravo/src/openbravo/pi/src-db/database/build-create.xml:53: The following error occurred while executing this line: /home/openbravo/src/openbravo/pi/src-db/database/build-create.xml:255: org.postgresql.util.PSQLException: ERROR: ERROR!!!! |
||
| Revision | 2018-09-21 08:16 by caristu | ||
| Steps To Reproduce | Using PostgreSQL 11: 1. Apply the attached patch (just for testing) that raises an exception in case an error happens during the execution of the ad_db_modified function. 2. Run ant install.source |
||
| Revision | 2018-09-20 19:28 by caristu | ||
| Description | The ad_db_modified fails in PostgreSQL11, because it is using a query[1] that makes use of the proisagg column which does not longer exists in the pg_proc catalog table. The function si failing silently because on case of error, the exception is caught and 'N' is returned. [1] https://code.openbravo.com/erp/devel/pi/file/tip/src-db/database/model/prescript-PostgreSql.sql#l1341 [^] |
||
| Revision | 2018-09-20 19:27 by caristu | ||
| Description | The ad_db_modified fails in PostgreSQL11, because it is using a query that makes use of the proisagg column which does not longer exists in the pg_proc catalog table. The function si failing silently because on case of error, the exception is caught and 'N' is returned. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |