0007426: When creating database in 2.40 - postgresql, an error occurs

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007426

Openbravo ERP

J. Demo data

public

2009-02-09 10:03

2009-03-04 10:38

Reporter

dalsasua

Assigned To

gorkaion

Priority

immediate

Severity

critical

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

rPath Linux

Product Version

2.40

Target Version

2.40

Fixed in Version

2.40MP3

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0007426: When creating database in 2.40 - postgresql, an error occurs

Description

During create.database execution, next error appears in a postgresql installation:

create.database.structure:
[createdatabase] Executing default prescript
[createdatabase] Executed 109 SQL command(s) with 0 error(s)
[createdatabase] Executing creation script
[createdatabase] for the complete database
[createdatabase] SQL Command failed with: ERROR: syntax error at or near "DBMS_OUTPUT"
[createdatabase] -- END M_INOUT_CANCEL
[createdatabase] -- -----------------------------------------------------------------------
[createdatabase] -- FUNCTION M_INOUT_CREATE
[createdatabase] -- -----------------------------------------------------------------------
[createdatabase] CREATE FUNCTION M_INOUT_CREATE(p_pinstance_id IN NUMERIC, p_inout_id OUT NUMERIC, p_order_id IN NUMERIC, p_invoice_id IN NUMERIC, p_forcedelivery IN CHAR, p_locator_id IN NUMERIC)
[createdatabase]
[createdatabase] AS $BODY$ DECLARE
[createdatabase] /*************************************************************************
[createdatabase] * The contents of this file are subject to the Compiere Public

...
...

[createdatabase] END ; $BODY$ LANGUAGE plpgsql;
[createdatabase] Executed 4987 SQL command(s) with 1 error(s)
[createdatabase] Executed 1 forced SQL command(s) with 0 error(s)
[createdatabase] Executing default postscript
[createdatabase] Executed 6 SQL command(s) with 0 error(s)

Steps To Reproduce

Check-out https://dev.openbravo.com/svn/openbravo/branches/r2.40, [^] configure a postgresql database, and run a create.database ant task.

Proposed Solution

Additional Information