Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2012-11-13 14:532012-11-21 06:06
ReportershuehnerView Statuspublic 
Assigned ToAugustoMauch 
PriorityurgentResolutionfixedFixed in Version3.0MP17
StatusclosedFix in branchFixed in SCM revision988b9a459b02
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0022286: Remove view user_objects (again) as it is unused and is causing trouble when upgrading from pgsql8.4 to >= pgsql9

DescriptionThe view user_objects exists as a system view on oracle and is created in the prescript on postgresql.

That view is no longer used since some time by any code in pi. The last user was the old implementation of delete-client which was removed from pi on 2011-09-27.

In issue 14642 that view was made compatible with PostgreSQL >= 9.0 which was needed as some internal postgres detail needed by that view changed between 8.4 and 9.1

That made the ERP already install fine on postgresql >9.0

However when doing a pg_dump of the database on pgsql8.4 and trying to import that dump on pgsql >= 9.0 an error is still raised as that view with the 8.4 definition cannot be imported into a 9.1 server.

As the view is no longer needed it should just be removed to allow easier upgrade to pgsql9.1 without showing any harmless but ugly error messages which will confuse users.

Note the same (deleting the view) was already tried in issue 14642 first, but back then needed to be backed out as the old delete client code still used that view, however that is no longer the case for over a year now, so that blocker does not apply.
Steps To Reproducerun install.source on top of pgsql8.4
run a pg_dump -Fc of that database
run pg_restore of that dump against a pgsql9.1 server
Notice that the user_objects view fails to be created and an error message about this is shown.
Proposed SolutionDelete the user_object view completely.

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00146423.0RC3 closedmarvintm PostgreSQL 9.0 support: replace pg_trigger.tgisconstraint 

-  Notes
hgbot (developer)
2012-11-13 18:45

Repository: erp/devel/pi
Changeset: 988b9a459b0262154ab083e85755b0471ed0105c
Author: Stefan Hühner <stefan.huehner <at>>
Date: Tue Nov 13 15:01:21 2012 +0100
URL: [^]

Fixed 22286. Remove unused user_objects view from prescript-postgresql
That view is no longer used as the last user the old delete client code
has been rewritten some time ago.
As that view is creating problem when upgrading from pgsql8.4 -> pgsql9.1
it is removed in this commit.

M src-db/database/model/excludeFilter.xml
M src-db/database/model/prescript-PostgreSql.sql
hudsonbot (developer)
2012-11-21 06:06

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-11-13 14:53 shuehner New Issue
2012-11-13 14:53 shuehner Assigned To => AugustoMauch
2012-11-13 14:53 shuehner Modules => Core
2012-11-13 15:03 shuehner Relationship added related to 0014642
2012-11-13 18:45 hgbot Checkin
2012-11-13 18:45 hgbot Note Added: 0054214
2012-11-13 18:45 hgbot Status new => resolved
2012-11-13 18:45 hgbot Resolution open => fixed
2012-11-13 18:45 hgbot Fixed in SCM revision => [^]
2012-11-14 12:24 marvintm Review Assigned To => marvintm
2012-11-14 12:24 marvintm Status resolved => closed
2012-11-14 12:24 marvintm Fixed in Version => 3.0MP17
2012-11-21 06:06 hudsonbot Checkin
2012-11-21 06:06 hudsonbot Note Added: 0054377

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker