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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0007425

2.40

closed

gorkaion

When creating database in 2.40 - postgresql, an error occurs

Notes
(0013249) svnbot (viewer) 2009-02-09 11:18	Repository: openbravo Revision: 12944 Author: gorkaion Date: 2009-02-09 11:18:32 +0100 (Mon, 09 Feb 2009) Fixed bug 7426. Changed to uppercase the dbms_output.put_line commands --- U branches/r2.40/src-db/database/model/functions/M_INOUT_CREATE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12944&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2009-02-09 10:07	rafaroda	Type	defect => backport
2009-02-09 10:07	rafaroda	fix_in_branch	=> 2.40
2009-02-09 11:18	svnbot	Checkin
2009-02-09 11:18	svnbot	Note Added: 0013249
2009-02-09 11:18	svnbot	Status	scheduled => resolved
2009-02-09 11:18	svnbot	Resolution	open => fixed
2009-02-09 11:18	svnbot	svn_revision	=> 12944
2009-03-03 17:32	psarobe	Fixed in Version	=> 2.40MP3
2009-03-04 10:38	psarobe	Status	resolved => closed