Changeset: 83cac6d77cd0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=83cac6d77cd0
Modified Files:
clients/mapiclient/mhelp.c
sql/ChangeLog.Oct2020
Branch: Oct2020
Log Message:
Updated ChangeLog and mhelp
diffs (25 lines):
diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -222,7 +222,7 @@ SQLhelp sqlhelp1[] = {
"See also
https://www.monetdb.org/Documentation/Manuals/SQLreference/Tables"},
{"CREATE TRIGGER",
"Define a triggered action for a table data update event",
- "CREATE [ OR REPLACE ] TRIGGER qname { BEFORE | AFTER }\n"
+ "CREATE [ OR REPLACE ] TRIGGER ident { BEFORE | AFTER }\n"
" { INSERT | DELETE | TRUNCATE | UPDATE [ OF ident_list ] }\n"
" ON qname [ REFERENCING trigger_reference [...] ] triggered_action",
"qname,ident_list,trigger_reference,triggered_action",
diff --git a/sql/ChangeLog.Oct2020 b/sql/ChangeLog.Oct2020
--- a/sql/ChangeLog.Oct2020
+++ b/sql/ChangeLog.Oct2020
@@ -1,3 +1,9 @@
# ChangeLog file for sql
# This file is updated with Maddlog
+* Thu Dec 10 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com>
+- CREATE [OR REPLACE] TRIGGER schema_name.trigger_name is now disallowed,
+ because the trigger will be stored on the same schema as the table it
+ refers to. Use a schema-qualified on the table reference (ie ON clause)
+ when necessary.
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
