details: /erp/devel/pi/rev/d6f404defcf2
changeset: 8447:d6f404defcf2
user: Antonio Moreno <antonio.moreno <at> openbravo.com>
date: Fri Sep 24 15:33:32 2010 +0200
summary: Fixed issue 14642. Removed the view so that the Openbravo full build
works in PostgreSQL 9.0
diffstat:
src-db/database/model/prescript-PostgreSql.sql | 13 -------------
1 files changed, 0 insertions(+), 13 deletions(-)
diffs (23 lines):
diff -r eac2e293ef02 -r d6f404defcf2
src-db/database/model/prescript-PostgreSql.sql
--- a/src-db/database/model/prescript-PostgreSql.sql Fri Sep 24 15:32:36
2010 +0200
+++ b/src-db/database/model/prescript-PostgreSql.sql Fri Sep 24 15:33:32
2010 +0200
@@ -1155,19 +1155,6 @@
ORDER BY table_name, index_name, column_position
/-- END
-SELECT * FROM drop_view('USER_OBJECTS')
-/-- END
-
-CREATE OR REPLACE VIEW USER_OBJECTS
-(TABLE_NAME, OBJECT_NAME, OBJECT_ID, OBJECT_TYPE, STATUS)
-AS
-SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_TRIGGER.TGNAME), PG_TRIGGER.TGFOID,
TO_CHAR('TRIGGER'), CASE is_Trigger_Enabled(PG_TRIGGER.TGNAME) WHEN TRUE THEN
TO_CHAR('VALID') ELSE TO_CHAR('INVALID') END
-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
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
