Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002268 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | minor | always | 2007-11-15 09:27 | 2008-06-12 09:43 | |||
| Reporter | cromero | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40alpha-r2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0002268: View USER_OBJECTS compatible for Postgres 8.3 | |||||||
| Description | 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0002662) cromero (viewer) 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 |
|
(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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |