Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023603Openbravo ERP09. Financial managementpublic2013-04-22 09:582013-05-07 16:41
Reportershuehner 
Assigned Todmiguelez 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toshuehner
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023603: 3 warnings related to views are always shown on every pg_restore
DescriptionThe following warnings are shown in every pg_restore:

pg_restore: WARNING: column "delete_btn" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
pg_restore: WARNING: column "em_aprm_modif_paym_sched" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
pg_restore: WARNING: column "em_aprm_modif_paym_out_sched" has type "unknown"
DETAIL: Proceeding with relation creation anyway.

As far as we know those are harmless but may confuse users checking on warnigns during pg_restore.

They are triggered by using i.e.

'N' as somealias

as a part of a view definition.

A quick check showed that changing those to to_char('N') does silence the warning.

A small patch doing this change is attached.

This does survive a try-run but is not tested otherwise.

Note: one or both of those view definitions seem not used anymore so another option would be to remove those also.
Steps To ReproduceTake a pi workspace
run a pg_dump of the underlying database
create a new empty database and restore the dump into it.
Check on warnings shown during restore.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 23603.diff (7,780) 2013-04-22 09:59
https://issues.openbravo.com/file_download.php?file_id=6107&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-04-22 09:58shuehnerNew Issue
2013-04-22 09:58shuehnerAssigned To => dmiguelez
2013-04-22 09:58shuehnerModules => Core
2013-04-22 09:58shuehnerOBNetwork customer => No
2013-04-22 09:58shuehnerTriggers an Emergency Pack => No
2013-04-22 09:59shuehnerFile Added: 23603.diff
2013-04-23 10:57hgbotCheckin
2013-04-23 10:57hgbotNote Added: 0058119
2013-04-23 10:57hgbotStatusnew => resolved
2013-04-23 10:57hgbotResolutionopen => fixed
2013-04-23 10:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/191b774fbb863439071eebf0325fcb2fcf2b7a91 [^]
2013-04-23 21:03hudsonbotCheckin
2013-04-23 21:03hudsonbotNote Added: 0058156
2013-04-25 14:04dmiguelezReview Assigned To => shuehner
2013-05-07 16:41dmiguelezNote Added: 0058490
2013-05-07 16:41dmiguelezStatusresolved => closed

Notes
(0058119)
hgbot   
2013-04-23 10:57   
Repository: erp/devel/pi
Changeset: 191b774fbb863439071eebf0325fcb2fcf2b7a91
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Apr 22 19:17:06 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/191b774fbb863439071eebf0325fcb2fcf2b7a91 [^]

Fixes Issue 23603. In views changes 'N' to TO_CHAR('N') for avoid
warnings.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_FINACC_TRANSACTION_V.xml
M src-db/database/model/views/FIN_PAYMENT_SCHED_INV_V.xml
---
(0058156)
hudsonbot   
2013-04-23 21:03   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f6ee8c2944a0 [^]

Maturity status: Test
(0058490)
dmiguelez   
2013-05-07 16:41   
Code Review + Testing Ok