Changeset: 9ce412fe9965 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9ce412fe9965
Modified Files:
        sql/scripts/97_comments.sql
        sql/scripts/99_system.sql
Branch: Mar2018
Log Message:

Move creation of sys.systemfunctions back to 99_system.sql


diffs (24 lines):

diff --git a/sql/scripts/97_comments.sql b/sql/scripts/97_comments.sql
--- a/sql/scripts/97_comments.sql
+++ b/sql/scripts/97_comments.sql
@@ -3,8 +3,3 @@
 -- file, You can obtain one at http://mozilla.org/MPL/2.0/.
 --
 -- Copyright 1997 - July 2008 CWI, August 2008 - 2018 MonetDB B.V.
-
--- This table used to be in 99_system.sql but we need the systemfunctions table
--- in sys.describe_all_objects and sys.commented_function_signatures defined 
below.
-CREATE TABLE sys.systemfunctions (function_id INTEGER NOT NULL);
-GRANT SELECT ON sys.systemfunctions TO PUBLIC;
diff --git a/sql/scripts/99_system.sql b/sql/scripts/99_system.sql
--- a/sql/scripts/99_system.sql
+++ b/sql/scripts/99_system.sql
@@ -5,6 +5,8 @@
 -- Copyright 1997 - July 2008 CWI, August 2008 - 2018 MonetDB B.V.
 
 -- only system functions until now
+create table sys.systemfunctions (function_id integer not null);
+grant select on sys.systemfunctions to public;
 insert into systemfunctions select id from functions;
 
 create trigger system_update_schemas after update on sys.schemas for each 
statement call sys_update_schemas();
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to