Changeset: 14856d5c1d3d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/14856d5c1d3d
Modified Files:
sql/backends/monet5/sql_upgrades.c
Branch: ts_and_tz_to_str_fix
Log Message:
Drop function and recreate with proper grants.
diffs (17 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
@@ -5766,9 +5766,13 @@ sql_update_jun2023(Client c, mvc *sql, s
sql->session->status = 0;
sql->errstr[0] = '\0';
pos = snprintf(buf, bufsize,
+ "DROP FUNCTION \"timestamp_to_str\"
CASCADE;"
"CREATE FUNCTION
\"timestamp_to_str\"(d TIMESTAMP, format STRING) RETURNS STRING "
"EXTERNAL NAME
mtime.\"timestamp_to_str\";\n"
+ "CREATE FUNCTION
\"timestamp_to_str\"(d TIMESTAMP WITH TIME ZONE, format STRING) RETURNS STRING "
+ "EXTERNAL NAME
mtime.\"timestamp_to_str\";\n"
"GRANT EXECUTE ON FUNCTION
\"timestamp_to_str\"(TIMESTAMP, STRING) TO PUBLIC;\n"
+ "GRANT EXECUTE ON FUNCTION
\"timestamp_to_str\"(TIMESTAMP WITH TIME ZONE, STRING) TO PUBLIC;\n"
"UPDATE sys.functions SET system =
true WHERE system <> true AND name = 'timestamp_to_str' "
"AND schema_id = 2000 and type =
%d;\n", F_FUNC);
assert(pos < bufsize);
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
