0007425: 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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

backport

0007426

2.40

closed

gorkaion

When creating database in 2.40 - postgresql, an error occurs

Notes
(0013246) rafaroda (viewer) 2009-02-09 10:08	No change is required in trunk source code. Backport to 2.40 maintenance branch remains open: https://issues.openbravo.com/view.php?id=7426 [^]

Issue History
Date Modified	Username	Field	Change
2009-02-09 10:03	dalsasua	New Issue
2009-02-09 10:03	dalsasua	Assigned To	=> rafaroda
2009-02-09 10:03	dalsasua	sf_bug_id	0 => 2580859
2009-02-09 10:03	dalsasua	OBNetwork customer	=> No
2009-02-09 10:03	dalsasua	Regression testing	=> No
2009-02-09 10:07	rafaroda	Assigned To	rafaroda => gorkaion
2009-02-09 10:07	rafaroda	Priority	normal => immediate
2009-02-09 10:07	rafaroda	Severity	major => critical
2009-02-09 10:07	rafaroda	version	=> 2.40
2009-02-09 10:07	rafaroda	Status	new => scheduled
2009-02-09 10:07	rafaroda	fix_in_branch	=> trunk
2009-02-09 10:08	rafaroda	Status	scheduled => closed
2009-02-09 10:08	rafaroda	Note Added: 0013246
2009-02-09 10:08	rafaroda	Resolution	open => no change required