Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023603
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminorhave not tried2013-04-22 09:582013-05-07 16:41
ReportershuehnerView Statuspublic 
Assigned Todmiguelez 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision191b774fbb86
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toshuehner
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023603: 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.
TagsNo tags attached.
Attached Filesdiff file icon 23603.diff [^] (7,780 bytes) 2013-04-22 09:59 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0058119)
hgbot (developer)
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 (developer)
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 (developer)
2013-05-07 16:41

Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2013-04-22 09:58 shuehner New Issue
2013-04-22 09:58 shuehner Assigned To => dmiguelez
2013-04-22 09:58 shuehner Modules => Core
2013-04-22 09:58 shuehner Triggers an Emergency Pack => No
2013-04-22 09:59 shuehner File Added: 23603.diff
2013-04-23 10:57 hgbot Checkin
2013-04-23 10:57 hgbot Note Added: 0058119
2013-04-23 10:57 hgbot Status new => resolved
2013-04-23 10:57 hgbot Resolution open => fixed
2013-04-23 10:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/191b774fbb863439071eebf0325fcb2fcf2b7a91 [^]
2013-04-23 21:03 hudsonbot Checkin
2013-04-23 21:03 hudsonbot Note Added: 0058156
2013-04-25 14:04 dmiguelez Review Assigned To => shuehner
2013-05-07 16:41 dmiguelez Note Added: 0058490
2013-05-07 16:41 dmiguelez Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker