Changeset: 19831406edaa for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=19831406edaa
Modified Files:
sql/backends/monet5/sql_upgrades.c
Branch: default
Log Message:
Update upgrade: MAL module sysmon.
diffs (36 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2943,14 +2943,29 @@ sql_update_default(Client c, mvc *sql, c
"\"finished\" timestamp,\n"
"\"workers\" int,\n"
"\"memory\" int)\n"
- " external name sql.sysmon_queue;\n"
+ " external name sysmon.queue;\n"
"grant execute on function sys.queue to
public;\n"
"create view sys.queue as select * from
sys.queue();\n"
- "grant select on sys.queue to
public;\n");
+ "grant select on sys.queue to public;\n"
+ "drop procedure sys.pause(bigint);\n"
+ "drop procedure sys.resume(bigint);\n"
+ "drop procedure sys.stop(bigint);\n"
+ "create procedure sys.pause(tag
bigint)\n"
+ "external name sysmon.pause;\n"
+ "grant execute on procedure
sys.pause(bigint) to public;\n"
+ "create procedure sys.resume(tag
bigint)\n"
+ "external name sysmon.resume;\n"
+ "grant execute on procedure
sys.resume(bigint) to public;\n"
+ "create procedure sys.stop(tag
bigint)\n"
+ "external name sysmon.stop;\n"
+ "grant execute on procedure
sys.stop(bigint) to public;\n");
pos += snprintf(buf + pos, bufsize - pos,
"update sys.functions set system = true
where schema_id = (select id from sys.schemas where name = 'sys')"
- " and name = 'queue' and type = %d;\n",
(int) F_UNION);
+ " and name = 'queue' and type = %d;\n"
+ "update sys.functions set system = true
where schema_id = (select id from sys.schemas where name = 'sys')"
+ " and name in ('pause', 'resume',
'stop') and type = %d;\n",
+ (int) F_UNION, (int) F_PROC);
pos += snprintf(buf + pos, bufsize - pos,
"update sys._tables set system = true
where schema_id = (select id from sys.schemas where name = 'sys')"
" and name = 'queue';\n");
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
