Changeset: c7f3138b47ee for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c7f3138b47ee
Modified Files:
sql/scripts/75_storagemodel.sql
Branch: Feb2013
Log Message:
Fully qualify schemas so that we don't get an error during upgrade to
Feb2013-SP1.
diffs (18 lines):
diff --git a/sql/scripts/75_storagemodel.sql b/sql/scripts/75_storagemodel.sql
--- a/sql/scripts/75_storagemodel.sql
+++ b/sql/scripts/75_storagemodel.sql
@@ -50,7 +50,7 @@ create table storagemodelinput(
update _tables
set system = true
where name = 'storagemodelinput'
- and schema_id = (select id from schemas where name = 'sys');
+ and schema_id = (select id from sys.schemas where name = 'sys');
-- this table can be adjusted to reflect the anticipated final database size
-- The model input can be derived from the current database using
@@ -159,4 +159,4 @@ from storagemodel() group by "schema","t
update _tables
set system = true
where name = 'tablestoragemodel'
- and schema_id = (select id from schemas where name = 'sys');
+ and schema_id = (select id from sys.schemas where name = 'sys');
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
