details: https://code.openbravo.com/erp/devel/main/rev/c19182955870
changeset: 18519:c19182955870
user: Stefan Hühner <stefan.huehner <at> openbravo.com>
date: Tue Nov 13 15:01:21 2012 +0100
summary: 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.
diffstat:
src-db/database/model/excludeFilter.xml | 1 -
src-db/database/model/prescript-PostgreSql.sql | 40 --------------------------
2 files changed, 0 insertions(+), 41 deletions(-)
diffs (61 lines):
diff -r 4eb028c733a4 -r c19182955870 src-db/database/model/excludeFilter.xml
--- a/src-db/database/model/excludeFilter.xml Mon Nov 12 19:34:06 2012 +0100
+++ b/src-db/database/model/excludeFilter.xml Tue Nov 13 15:01:21 2012 +0100
@@ -11,7 +11,6 @@
<excludedView name="USER_CONSTRAINTS"/>
<excludedView name="USER_INDEXES"/>
<excludedView name="USER_IND_COLUMNS"/>
- <excludedView name="USER_OBJECTS"/>
<excludedView name="USER_TAB_COLUMNS"/>
<excludedView name="USER_TRIGGERS"/>
<excludedView name="V$VERSION"/>
diff -r 4eb028c733a4 -r c19182955870
src-db/database/model/prescript-PostgreSql.sql
--- a/src-db/database/model/prescript-PostgreSql.sql Mon Nov 12 19:34:06
2012 +0100
+++ b/src-db/database/model/prescript-PostgreSql.sql Tue Nov 13 15:01:21
2012 +0100
@@ -1169,46 +1169,6 @@
ORDER BY table_name, index_name, column_position
/-- END
-SELECT * FROM drop_view('USER_OBJECTS')
-/-- END
-
-CREATE or REPLACE function create_user_objects() returns varchar as '
-DECLARE
- cnt int4;
-BEGIN
- SELECT into cnt count(*) from version() where version like ''%PostgreSQL
9.%'';
- if cnt > 0 then
- execute ''CREATE OR REPLACE VIEW USER_OBJECTS
-(TABLE_NAME, OBJECT_NAME, OBJECT_ID)
-AS
-SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_TRIGGER.TGNAME), PG_TRIGGER.TGFOID
-FROM PG_TRIGGER, PG_NAMESPACE, PG_CLASS
-WHERE PG_TRIGGER.TGRELID = PG_CLASS.OID
-AND PG_TRIGGER.TGISINTERNAL = FALSE
-AND PG_CLASS.RELNAMESPACE = PG_NAMESPACE.OID
-AND PG_NAMESPACE.NSPNAME = CURRENT_SCHEMA()'';
-else
-execute ''CREATE OR REPLACE VIEW USER_OBJECTS
-(TABLE_NAME, OBJECT_NAME, OBJECT_ID)
-AS
-SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_TRIGGER.TGNAME), PG_TRIGGER.TGFOID
-FROM PG_TRIGGER, PG_NAMESPACE, PG_CLASS
-WHERE PG_TRIGGER.TGRELID = PG_CLASS.OID
-AND PG_TRIGGER.TGISCONSTRAINT = FALSE
-AND PG_CLASS.RELNAMESPACE = PG_NAMESPACE.OID
-AND PG_NAMESPACE.NSPNAME = CURRENT_SCHEMA()'';
- end if;
- return null;
-END;'
-language 'plpgsql'
-/-- END
-
-SELECT * FROM create_user_objects()
-/-- END
-
-DROP FUNCTION create_user_objects()
-/-- END
-
SELECT * FROM drop_view('USER_CONS_COLUMNS')
/-- END
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
