Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0002268Openbravo ERPZ. Otherspublic2007-11-15 09:272008-06-12 09:43
cromero 
cromero 
normalminoralways
closedfixed 
5
 
2.40alpha-r2 
No
Core
No
0002268: View USER_OBJECTS compatible for Postgres 8.3
We have some problem with compatibility with various postgres versions. In the prescript for postgres a view 'USER_OBJECTS' is created which references PG_TRIGGER.TGENABLED. The definition of TGENABLED is boolean in 8.2 and changed to 'char' in 8.3 leading to an operator does not exist (char = boolean) error.

According to the http://www.postgresql.org/docs/8.3/static/catalog-pg-trigger.html [^] doc there is a mapping for true/false but in don't see an option to support both 8.2 / 8.3 at the moment which one script.

huehner
No tags attached.
Issue History

Notes
(0005857)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1832302 [^]
(0002662)
cromero   
2007-11-15 09:32   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500614
Originator: YES

I have uploaded to the trunk a modified prescript for Postgres to avoid this problem in 8.3 version.

I have attached also the solution below.

Thank you.

Carlos Romero
Openbravo Team
File Added: USER_OBJECTS-pos.sql