Changeset: 1a049881e451 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1a049881e451
Modified Files:
        sql/backends/monet5/sql_upgrades.c
Branch: default
Log Message:

Add upgrade code for .snapshot


diffs (19 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
@@ -2952,6 +2952,15 @@ sql_update_default(Client c, mvc *sql, c
                                        "external name 
\"sql\".\"sql_variables\";\n"
                                        "grant execute on function 
\"sys\".\"var\" to public;\n");
 
+                       /* .snapshot user */
+                       pos += snprintf(buf + pos, bufsize - pos,
+                               "create user \".snapshot\""
+                               " with encrypted password 
'00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'"
+                               " name 'Snapshot User'"
+                               " schema sys;"
+                               "grant execute on procedure sys.hot_snapshot to 
\".snapshot\";"
+                       );
+
                        /* update system tables so that the content
                         * looks more like what it would be if sys.var
                         * had been defined by the C code in
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to