List:Commits« Previous MessageNext Message »
From:jon.stephens Date:February 4 2011 10:37am
Subject:svn commit - mysqldoc@docsrva: r24973 - in trunk: refman-5.1 refman-5.5 refman-5.6 refman-6.0
View as plain text  
Author: jstephens
Date: 2011-02-04 11:37:57 +0100 (Fri, 04 Feb 2011)
New Revision: 24973

Log:

You can't set a trigger on an I_S table (Thanks, AJ!)



Modified:
   trunk/refman-5.1/information-schema.xml
   trunk/refman-5.5/information-schema.xml
   trunk/refman-5.6/information-schema.xml
   trunk/refman-6.0/information-schema.xml


Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml	2011-02-03 11:26:22 UTC (rev 24972)
+++ trunk/refman-5.1/information-schema.xml	2011-02-04 10:37:57 UTC (rev 24973)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 0; 626 bytes

@@ -62,6 +62,12 @@
   </para>
 
   <para>
+    The fact that <literal>INFORMATION_SCHEMA</literal> tables are
+    actually views also means that you cannot set triggers on them. See
+    <xref linkend="triggers"/>.
+  </para>
+
+  <para>
     Here is an example of a statement that retrieves information from
     <literal>INFORMATION_SCHEMA</literal>:
   </para>


Modified: trunk/refman-5.5/information-schema.xml
===================================================================
--- trunk/refman-5.5/information-schema.xml	2011-02-03 11:26:22 UTC (rev 24972)
+++ trunk/refman-5.5/information-schema.xml	2011-02-04 10:37:57 UTC (rev 24973)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 0; 626 bytes

@@ -62,6 +62,12 @@
   </para>
 
   <para>
+    The fact that <literal>INFORMATION_SCHEMA</literal> tables are
+    actually views also means that you cannot set triggers on them. See
+    <xref linkend="triggers"/>.
+  </para>
+
+  <para>
     Here is an example of a statement that retrieves information from
     <literal>INFORMATION_SCHEMA</literal>:
   </para>


Modified: trunk/refman-5.6/information-schema.xml
===================================================================
--- trunk/refman-5.6/information-schema.xml	2011-02-03 11:26:22 UTC (rev 24972)
+++ trunk/refman-5.6/information-schema.xml	2011-02-04 10:37:57 UTC (rev 24973)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 0; 626 bytes

@@ -62,6 +62,12 @@
   </para>
 
   <para>
+    The fact that <literal>INFORMATION_SCHEMA</literal> tables are
+    actually views also means that you cannot set triggers on them. See
+    <xref linkend="triggers"/>.
+  </para>
+
+  <para>
     Here is an example of a statement that retrieves information from
     <literal>INFORMATION_SCHEMA</literal>:
   </para>


Modified: trunk/refman-6.0/information-schema.xml
===================================================================
--- trunk/refman-6.0/information-schema.xml	2011-02-03 11:26:22 UTC (rev 24972)
+++ trunk/refman-6.0/information-schema.xml	2011-02-04 10:37:57 UTC (rev 24973)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 0; 626 bytes

@@ -62,6 +62,12 @@
   </para>
 
   <para>
+    The fact that <literal>INFORMATION_SCHEMA</literal> tables are
+    actually views also means that you cannot set triggers on them. See
+    <xref linkend="triggers"/>.
+  </para>
+
+  <para>
     Here is an example of a statement that retrieves information from
     <literal>INFORMATION_SCHEMA</literal>:
   </para>


Thread
svn commit - mysqldoc@docsrva: r24973 - in trunk: refman-5.1 refman-5.5 refman-5.6 refman-6.0jon.stephens4 Feb