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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040317
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2019-03-05 13:552019-03-28 14:56
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR19Q2
StatusclosedFix in branchFixed in SCM revision8b497714669e
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040317: can't restore pg dump of a retail instance

DescriptionRetail instances cannot be recovered with pg_restore.
Steps To Reproduce0. Update a retail instance to a version including POS changest 8afc424cc7a4 [1]
1. pg_dump it
2. restore it with pg_restore

  ERROR:
   pg_restore: [archiver (db)] could not execute query: ERROR: function dateformat() does not exist
   LINE 1: SELECT to_timestamp(to_char($1, dateFormat()), dateFormat())
                                           ^
   HINT: No function matches the given name and argument types. You might need to add explicit type casts.
   QUERY: SELECT to_timestamp(to_char($1, dateFormat()), dateFormat())
   CONTEXT: PL/pgSQL function public.trunc(timestamp without time zone) line 3 at RETURN
       Command was: CREATE INDEX obpos_app_cashup_date_idx ON public.obpos_app_cashup USING btree (public.trunc(cashupdate));



[1] hg log -r 8afc424cc7a4 -p
changeset: 11001:8afc424cc7a4
user: Eduardo Argal Guibert <eduardo.argal@openbravo.com>
date: Wed Feb 27 18:43:19 2019 +0100
summary: Adds new index to OBPOS_APP_CASHUP for CASHUPDATE

diff -r ed15e5ff9b53 -r 8afc424cc7a4 src-db/database/model/tables/OBPOS_APP_CASHUP.xml
--- a/src-db/database/model/tables/OBPOS_APP_CASHUP.xml Wed Feb 27 13:18:39 2019 +0100
+++ b/src-db/database/model/tables/OBPOS_APP_CASHUP.xml Wed Feb 27 18:43:19 2019 +0100
@@ -112,6 +112,9 @@
       <foreign-key foreignTable="OBPOS_APP_CASHUP" name="OBPOS_APPCASH_PARENT">
         <reference local="OBPOS_PARENT_CASHUP_ID" foreign="OBPOS_APP_CASHUP_ID"/>
       </foreign-key>
+ <index name="OBPOS_APP_CASHUP_DATE_IDX" unique="false">
+ <index-column name="functionBasedColumn" functionExpression="TRUNC(CASHUPDATE)"/>
+ </index>
       <index name="OBPOS_APP_CASHUP_PARENT_IDX" unique="false">
         <index-column name="OBPOS_PARENT_CASHUP_ID"/>
         <whereClause><![CDATA[OBPOS_PARENT_CASHUP_ID IS NOT NULL]]></whereClause>
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0038179 closedalostale cannot restore pg dump 

-  Notes
(0110231)
hgbot (developer)
2019-03-05 14:01

Repository: erp/devel/pi
Changeset: 8b497714669eedb6476c9d6abedbc33a4012518e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Mar 05 13:58:17 2019 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8b497714669eedb6476c9d6abedbc33a4012518e [^]

fixed bug 40317: can't restore pg dump of a retail instance

  Added search_path to trunc functions, which where missing in fix for 0038179.
  This is necessary to enable pg_restore when trunc is used in a contraint or
  index as it calls other functions not in pg_catalog schema.

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0110322)
caristu (developer)
2019-03-08 13:36

Code reviewed + tested OK.
(0110847)
hudsonbot (developer)
2019-03-28 14:56

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/b2fbc1588df4 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2019-03-05 13:55 alostale New Issue
2019-03-05 13:55 alostale Assigned To => platform
2019-03-05 13:55 alostale Modules => Core
2019-03-05 13:55 alostale Triggers an Emergency Pack => No
2019-03-05 13:55 alostale Relationship added related to 0038179
2019-03-05 13:55 alostale Assigned To platform => alostale
2019-03-05 13:59 alostale Review Assigned To => caristu
2019-03-05 14:01 hgbot Checkin
2019-03-05 14:01 hgbot Note Added: 0110231
2019-03-05 14:01 hgbot Status new => resolved
2019-03-05 14:01 hgbot Resolution open => fixed
2019-03-05 14:01 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8b497714669eedb6476c9d6abedbc33a4012518e [^]
2019-03-08 13:36 caristu Note Added: 0110322
2019-03-08 13:36 caristu Status resolved => closed
2019-03-08 13:36 caristu Fixed in Version => 3.0PR19Q2
2019-03-28 14:56 hudsonbot Checkin
2019-03-28 14:56 hudsonbot Note Added: 0110847


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker