Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002698Openbravo ERP01. General setuppublic2008-03-07 18:002008-07-08 10:52
Reportercromero 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002698: Error renumbering in 'Price List Schema' in PostgreSQL
DescriptionIn menu 'Master Data Management' -> 'Pricing' -> 'Price List Schema', OB makes a mistake when I click on 'Renumber'.

The error is: "relation 'seqno' in FOR UPDATE / SHARE clause not found in FROM clause"
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003679 closed marvintm Error renumbering in 'Price List Schema' in Post 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-08 10:52psarobeStatusresolved => closed
2008-07-08 10:52psarobeFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0006287)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1909687 [^]
(0003297)
cromero   
2008-03-07 18:08   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: YES

related to forum post:
https://sourceforge.net/forum/message.php?msg_id=4801271 [^]
(0003298)
marvintm   
2008-04-14 15:28   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1952914
Originator: NO

We have tested this bug in the subversion repository and it has just been fixed.

Note that the only supported version of the application is the one in subversion. So it is possible that this was a bug in a previous version that is already fixed.
(0003299)
marvintm   
2008-04-14 15:28   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1952914
Originator: NO

Now "FROM UPDATE OF" expressions in PL/SQL code should be correctly translated in PostgreSQL.