0006392: View in different schema break the database update process

(0011446)
rafaroda (developer)
2008-12-16 18:11

Ville, could you please provide extended steps to reproduce this issue? Thank you.

(0011456)
villind (developer)
2008-12-16 20:06

CREATE SCHEMA import;

CREATE OR REPLACE VIEW import.v_test AS
SELECT now()::timestamp without time zone AS now;

-------------
ant update.database

(0011925)
iciordia (manager)
2009-01-05 18:50

Antonio,

the problem seems to be that dbsourcemanager is querying postgresql dictionary without filtering by schema, at least when retrieving views.

Can you please check it?

Ismael

(0011937)
svnbot (reporter)
2009-01-07 10:00

Repository: dbsourcemanager
Revision: 199
Author: marvintm
Date: 2009-01-07 10:00:16 +0100 (Wed, 07 Jan 2009)

Fixed bug 6392. Now only views of current schema will be loaded when loading the database model.

---
U trunk/src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=199&sc=1 [^]

(0011938)
svnbot (reporter)
2009-01-07 10:03

Repository: openbravo
Revision: 11670
Author: marvintm
Date: 2009-01-07 10:03:34 +0100 (Wed, 07 Jan 2009)

Fixed bug 6392. Now only views of current schema will be loaded when loading the database model.

---
U trunk/src-db/database/lib/dbsourcemanager.jar
---

https://dev.openbravo.com/websvn/openbravo/?rev=11670&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-12-07 21:45	villind	New Issue
2008-12-16 18:11	rafaroda	Note Added: 0011446
2008-12-16 18:11	rafaroda	Status	new => feedback
2008-12-16 20:06	villind	Note Added: 0011456
2008-12-18 12:38	jpabloae	Sticky Issue	No => Yes
2008-12-18 12:39	jpabloae	Sticky Issue	Yes => No
2008-12-18 12:39	jpabloae	Tag Attached: dbsm_migrate
2008-12-18 12:41	jpabloae	Project	@4@ => Openbravo ERP
2008-12-18 12:41	jpabloae	Category	=> Y. DBSourceManager
2008-12-18 12:43	jpabloae	Assigned To	=> marvintm
2009-01-05 18:48	iciordia	Status	feedback => scheduled
2009-01-05 18:48	iciordia	fix_in_branch	=> trunk
2009-01-05 18:50	iciordia	Note Added: 0011925
2009-01-07 10:00	svnbot	Checkin
2009-01-07 10:00	svnbot	Note Added: 0011937
2009-01-07 10:00	svnbot	Status	scheduled => resolved
2009-01-07 10:00	svnbot	Resolution	open => fixed
2009-01-07 10:00	svnbot	svn_revision	=> 199
2009-01-07 10:03	svnbot	Checkin
2009-01-07 10:03	svnbot	Note Added: 0011938
2009-01-07 10:03	svnbot	svn_revision	199 => 11670
2009-04-21 11:09	psarobe	Status	resolved => closed
2009-04-22 00:00	anonymous	sf_bug_id	0 => 2777917

Notes
(0011446) rafaroda (developer) 2008-12-16 18:11	Ville, could you please provide extended steps to reproduce this issue? Thank you.

(0011456) villind (developer) 2008-12-16 20:06	CREATE SCHEMA import; CREATE OR REPLACE VIEW import.v_test AS SELECT now()::timestamp without time zone AS now; ------------- ant update.database

(0011925) iciordia (manager) 2009-01-05 18:50	Antonio, the problem seems to be that dbsourcemanager is querying postgresql dictionary without filtering by schema, at least when retrieving views. Can you please check it? Ismael

(0011937) svnbot (reporter) 2009-01-07 10:00	Repository: dbsourcemanager Revision: 199 Author: marvintm Date: 2009-01-07 10:00:16 +0100 (Wed, 07 Jan 2009) Fixed bug 6392. Now only views of current schema will be loaded when loading the database model. --- U trunk/src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=199&sc=1 [^]

(0011938) svnbot (reporter) 2009-01-07 10:03	Repository: openbravo Revision: 11670 Author: marvintm Date: 2009-01-07 10:03:34 +0100 (Wed, 07 Jan 2009) Fixed bug 6392. Now only views of current schema will be loaded when loading the database model. --- U trunk/src-db/database/lib/dbsourcemanager.jar --- https://dev.openbravo.com/websvn/openbravo/?rev=11670&sc=1 [^]

Relationships [ Relation Graph ] [ Dependency Graph ]