[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-checkins
Subject:    MonetDB: geo - Added spatial_ref_sys_srid_pkey in the keys that ...
From:       Foteini Alvanaki <commits () monetdb ! org>
Date:       2015-04-29 13:15:34
Message-ID: hg.cd095154deec.1430313334.6315528441665844383 () monetdb2 ! cwi-incubator ! nl
[Download RAW message or body]

Changeset: cd095154deec for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cd095154deec
Modified Files:
	sql/test/DropCascade/Tests/drop_columns_cascade.sql
	sql/test/DropCascade/Tests/drop_pkey_cascade.sql
Branch: geo
Log Message:

Added spatial_ref_sys_srid_pkey in the keys that are ignored in drop_columns_cascade \
and drop_pkey_cascade


diffs (24 lines):

diff --git a/sql/test/DropCascade/Tests/drop_columns_cascade.sql \
                b/sql/test/DropCascade/Tests/drop_columns_cascade.sql
--- a/sql/test/DropCascade/Tests/drop_columns_cascade.sql
+++ b/sql/test/DropCascade/Tests/drop_columns_cascade.sql
@@ -49,7 +49,7 @@ select name from functions where name = 
 select name from triggers where name = 'test1';
 select name from idxs where name = 'id_index';
 select name from columns where name = 'id' and table_id in (select id from tables \
                where name = 't1' or name = 't2');
-select name from keys where name not in ('files_pkey_file_id', 'sq_pkey_sn_file_id', \
'sq_fkey_file_id', 'rg_pkey_id_file_id', 'rg_fkey_file_id', 'pg_pkey_id_file_id', \
'pg_fkey_file_id'); +select name from keys where name not in ('files_pkey_file_id', \
'sq_pkey_sn_file_id', 'sq_fkey_file_id', 'rg_pkey_id_file_id', 'rg_fkey_file_id', \
'pg_pkey_id_file_id', 'pg_fkey_file_id', 'spatial_ref_sys_srid_pkey');  
 
 --Just for debug
diff --git a/sql/test/DropCascade/Tests/drop_pkey_cascade.sql \
                b/sql/test/DropCascade/Tests/drop_pkey_cascade.sql
--- a/sql/test/DropCascade/Tests/drop_pkey_cascade.sql
+++ b/sql/test/DropCascade/Tests/drop_pkey_cascade.sql
@@ -7,7 +7,7 @@ ALTER TABLE t1 DROP CONSTRAINT t1_id_pke
 
 select name from tables where name = 't1';
 select name from tables where name = 't2';
-select name from keys where name not in ('files_pkey_file_id', 'sq_pkey_sn_file_id', \
'sq_fkey_file_id', 'rg_pkey_id_file_id', 'rg_fkey_file_id', 'pg_pkey_id_file_id', \
'pg_fkey_file_id'); +select name from keys where name not in ('files_pkey_file_id', \
'sq_pkey_sn_file_id', 'sq_fkey_file_id', 'rg_pkey_id_file_id', 'rg_fkey_file_id', \
'pg_pkey_id_file_id', 'pg_fkey_file_id', 'spatial_ref_sys_srid_pkey');  
 --just for debug
 --select * from dependencies;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list


[prev in list] [next in list] [prev in thread] [next in thread]