0002646: Postgres stored proc translator discards exception err msgs

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0002646	Openbravo ERP	Z. Others	public	2008-02-26 06:57	2008-06-12 09:43

Reporter	user71
Assigned To	user71
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	5	OS Version
Product Version
Target Version		Fixed in Version	2.40alpha-r2
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	0002646: Postgres stored proc translator discards exception err msgs
Description	OS: Linux - Centos 4 (test/prod) & Windows XP (dev) DB: Postgres 8.1.9 (test/prod) & 8.2.4 (dev) Release: trunk Browser: Firefox 2.0.0.6, IE 7 The postgres sql function translator converts plain RAISE; statements to RAISE EXCEPTION '%', ''; This often occurs in the final exception handling clause of functions as a way of passing on an exception raised earlier. When this happens the earlier exception message will be lost, whereas under Oracle a RAISE will preserver the error message. Fix is to use the SQLERRM variable which holds the current error message. Also would be nice to put message when raise exception is used to rollback transaction.
Steps To Reproduce
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change

Notes