[libgda] information-schema: updated to version 5

From: Daniel Espinosa Ortiz <despinosa src gnome org>
To: commits-list gnome org
Cc:
Subject: [libgda] information-schema: updated to version 5
Date: Fri, 8 Mar 2019 00:14:32 +0000 (UTC)

commit 2a6145d4d64acf946ab80087a6bdeed026dd87ce
Author: Daniel Espinosa Ortiz <esodan gmail com>
Date:   Thu Mar 7 18:11:36 2019 -0600

    information-schema: updated to version 5
    
    Fix https://gitlab.gnome.org/GNOME/libgda/issues/164

 doc/C/libgda/i_s_doc.xml              | 46 +++++++++++++++++------------------
 libgda/gda-meta-store.c               |  3 ++-
 tools/misc/information-schema-types.c |  2 +-
 3 files changed, 26 insertions(+), 25 deletions(-)
---
diff --git a/doc/C/libgda/i_s_doc.xml b/doc/C/libgda/i_s_doc.xml
index 59ff9d300..c8d99a50d 100644
--- a/doc/C/libgda/i_s_doc.xml
+++ b/doc/C/libgda/i_s_doc.xml
@@ -7,7 +7,7 @@ do not modify-->
   <sect3 id="is:_attributes">
     <title>_attributes table</title>
     <para>Table to store (key,value) pairs (keys starting with '_' are reserved)</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>att_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>att_value</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>att_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>att_value</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row></tbody></tgroup></informaltable></para>
   </sect3>
   <sect3 id="is:_information_schema_catalog_name">
     <title>_information_schema_catalog_name table</title>
@@ -17,7 +17,7 @@ do not modify-->
   <sect3 id="is:_schemata">
     <title>_schemata table</title>
     <para>List of schemas</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>catalog_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the 
schema</entry></row><row><entry>schema_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>schema_owner</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the 
schema</entry></row><row><entry>schema_internal</entry><entry>boolean</entry><entry></entry><entry>No</entry><entry>Tells
 if the schema is specific to the database implementation (and usually can't be 
modified)</entry></row><row><entry>schema_default</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry>Tells
 if the schema i
 s used b
 y default when creating a new table without schema name</entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>catalog_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the 
schema</entry></row><row><entry>schema_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>schema_owner</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the 
schema</entry></row><row><entry>schema_internal</entry><entry>boolean</entry><entry/><entry>No</entry><entry>Tells
 if the schema is specific to the database implementation (and usually can't be 
modified)</entry></row><row><entry>schema_default</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry>Tells
 if the schema is used by default whe
 n creati
 ng a new table without schema name</entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -29,12 +29,12 @@ do not modify-->
   <sect3 id="is:_builtin_data_types">
     <title>_builtin_data_types table</title>
     <para>List of built-in data types such as varchar, int, ...</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>short_type_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Short
 name of the data 
type</entry></row><row><entry>full_type_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Full
 name of the data 
type</entry></row><row><entry>gtype</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>synonyms</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>internal</entry><entry>boolean</entry><entry></entry><entry>No</entry><entry>Tells
 if the data type is reserved for 
 the data
 base implementation and should not be used in 
applications</entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>short_type_name</entry><entry>string</entry><entry/><entry>No</entry><entry>Short
 name of the data 
type</entry></row><row><entry>full_type_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Full
 name of the data 
type</entry></row><row><entry>gtype</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>synonyms</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>internal</entry><entry>boolean</entry><entry/><entry>No</entry><entry>Tells
 if the data type is reserved for the database implementation and shoul
 d not be
  used in applications</entry></row></tbody></tgroup></informaltable></para>
   </sect3>
   <sect3 id="is:_udt">
     <title>_udt table</title>
     <para>User defined data types</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>udt_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the data 
type</entry></row><row><entry>udt_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the schema that contains the data 
type</entry></row><row><entry>udt_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the data 
type</entry></row><row><entry>udt_gtype</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>GType
 associated to the data 
type</entry></row><row><entry>udt_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>udt_short_name</e
 ntry><en
 
try>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>udt_full_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>udt_internal</entry><entry>boolean</entry><entry></entry><entry>No</entry><entry>Tells
 if the data type is reserved for the database implementation and should not be used in 
applications</entry></row><row><entry>udt_owner</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>udt_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the data 
type</entry></row><row><entry>udt_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the schema that contains the data 
type</entry></row><row><entry>udt_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the data 
type</entry></row><row><entry>udt_gtype</entry><entry>string</entry><entry/><entry>Yes</entry><entry>GType 
associated to the data 
type</entry></row><row><entry>udt_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>udt_short_name</entry><entry>stri
 ng</entr
 
y><entry/><entry>No</entry><entry></entry></row><row><entry>udt_full_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>udt_internal</entry><entry>boolean</entry><entry/><entry>No</entry><entry>Tells
 if the data type is reserved for the database implementation and should not be used in 
applications</entry></row><row><entry>udt_owner</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -46,7 +46,7 @@ do not modify-->
   <sect3 id="is:_udt_columns">
     <title>_udt_columns table</title>
     <para>List of components for a user defined data type for composed data types (such as a complex number 
data type which has real and imaginary parts)</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>udt_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the user defined data type for which the column 
is</entry></row><row><entry>udt_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the schema that contains the user defined data type for which the column 
is</entry></row><row><entry>udt_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the user defined data type for which the column 
is</entry></row><row><entry>udt_column</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the column (part)</entry></row><row><entry>ordinal_position</
 entry><e
 ntry>gint</entry><entry></entry><entry>No</entry><entry>Column position, starts at 
1</entry></row><row><entry>data_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Data 
type of the column (if the column is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Array
 description if the column is an 
array</entry></row><row><entry>character_maximum_length</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_octet_length</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>numeric_precision</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>numeric_scale</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>datetime_precision</entry><entry>gint</entry><entry></entry><entry>Yes</entry><e
 ntry></e
 
ntry></row><row><entry>character_set_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_set_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_set_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>udt_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the user defined data type for which the column 
is</entry></row><row><entry>udt_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the schema that contains the user defined data type for which the column 
is</entry></row><row><entry>udt_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the user defined data type for which the column 
is</entry></row><row><entry>udt_column</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the column (part)</entry></row><row><entry>ordinal_position</
 entry><e
 ntry>gint</entry><entry/><entry>No</entry><entry>Column position, starts at 
1</entry></row><row><entry>data_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Data type 
of the column (if the column is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Array 
description if the column is an 
array</entry></row><row><entry>character_maximum_length</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_octet_length</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>numeric_precision</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>numeric_scale</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>datetime_precision</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_catalog</en
 try><ent
 
ry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -61,7 +61,7 @@ do not modify-->
   <sect3 id="is:_enums">
     <title>_enums table</title>
     <para>List of possible enumeration labels for enumerations</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>udt_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the ENUM user defined data 
type</entry></row><row><entry>udt_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the schema that contains the ENUM user defined data 
type</entry></row><row><entry>udt_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the ENUM user defined data 
type</entry></row><row><entry>label</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry></entry><entry>No</entry><entry>Position,
 starts at 1</
 entry></
 row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>udt_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the catalog that contains the ENUM user defined data 
type</entry></row><row><entry>udt_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the schema that contains the ENUM user defined data 
type</entry></row><row><entry>udt_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the ENUM user defined data 
type</entry></row><row><entry>label</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry/><entry>No</entry><entry>Position,
 starts at 1</entry><
 /row></t
 body></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -73,12 +73,12 @@ do not modify-->
   <sect3 id="is:_element_types">
     <title>_element_types table</title>
     <para>Array specific attributes for array data types</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>No
 specific meaning, used as a primary key, and for 
joining</entry></row><row><entry>object_catalog</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Name
 of the catalog that contains the object that uses the array being 
described</entry></row><row><entry>object_schema</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Name
 of the schema that contains the object that uses the array being 
described</entry></row><row><entry>object_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Name
 of the object that uses the array being described</entry></row><row>
 <entry>o
 bject_type</entry><entry>string</entry><entry></entry><entry>No</entry><entry>The type of the object that 
uses the array being described TABLE_COL, DOMAIN, UDT_COL, ROUTINE_COL, 
ROUTINE_PAR</entry></row><row><entry>data_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Base
 data type of the array (if the base data type is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Array
 description if the base data type is an 
array</entry></row><row><entry>min_cardinality</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>max_cardinality</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>No
 specific meaning, used as a primary key, and for 
joining</entry></row><row><entry>object_catalog</entry><entry>string</entry><entry/><entry>No</entry><entry>Name
 of the catalog that contains the object that uses the array being 
described</entry></row><row><entry>object_schema</entry><entry>string</entry><entry/><entry>No</entry><entry>Name
 of the schema that contains the object that uses the array being 
described</entry></row><row><entry>object_name</entry><entry>string</entry><entry/><entry>No</entry><entry>Name
 of the object that uses the array being described</entry></row><row><entry>object_type</e
 ntry><en
 try>string</entry><entry/><entry>No</entry><entry>The type of the object that uses the array being described 
TABLE_COL, DOMAIN, UDT_COL, ROUTINE_COL, 
ROUTINE_PAR</entry></row><row><entry>data_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Base
 data type of the array (if the base data type is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Array 
description if the base data type is an 
array</entry></row><row><entry>min_cardinality</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>max_cardinality</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
   </sect3>
   <sect3 id="is:_domains">
     <title>_domains table</title>
     <para>List of domains</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>domain_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of catalog that contains the 
domain</entry></row><row><entry>domain_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of schema that contains the 
domain</entry></row><row><entry>domain_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the 
domain</entry></row><row><entry>data_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Data
 type of the domain (if the domain is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry></entry><entry>Yes</
 entry><e
 ntry>Array description if the domain is an 
array</entry></row><row><entry>domain_gtype</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>character_maximum_length</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_octet_length</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of catalog that contains the associated 
collation</entry></row><row><entry>collation_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of schema that contains the associated 
collation</entry></row><row><entry>collation_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the associated 
collation</entry></row><row><entry>character_set_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of catalog 
 that con
 tains the associated character 
set</entry></row><row><entry>character_set_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of schema that contains the associated character 
set</entry></row><row><entry>character_set_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the associated character 
set</entry></row><row><entry>numeric_precision</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>numeric_scale</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>domain_default</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>domain_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>domain_short_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>domain_full_name</entry><entry>string</entry><entry></entry><e
 ntry>No<
 
/entry><entry></entry></row><row><entry>domain_internal</entry><entry>boolean</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>domain_owner</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>domain_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of catalog that contains the 
domain</entry></row><row><entry>domain_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of schema that contains the 
domain</entry></row><row><entry>domain_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the 
domain</entry></row><row><entry>data_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Data 
type of the domain (if the domain is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry/><entry>Yes</entry><entry>A
 rray des
 cription if the domain is an 
array</entry></row><row><entry>domain_gtype</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>character_maximum_length</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_octet_length</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of catalog that contains the associated 
collation</entry></row><row><entry>collation_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of schema that contains the associated 
collation</entry></row><row><entry>collation_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the associated 
collation</entry></row><row><entry>character_set_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of catalog that contains the associated character set</entry></row><row><e
 ntry>cha
 racter_set_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name of schema that contains 
the associated character 
set</entry></row><row><entry>character_set_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the associated character 
set</entry></row><row><entry>numeric_precision</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>numeric_scale</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>domain_default</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>domain_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>domain_short_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>domain_full_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>domain_internal</entry><entry>boolean</entry><entry/><entry>No</entry><en
 try></en
 
try></row><row><entry>domain_owner</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -93,7 +93,7 @@ do not modify-->
   <sect3 id="is:_tables">
     <title>_tables table</title>
     <para>List of tables (tables, views or other objects which can contain data)</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of catalog that contains the 
table</entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of schema that contains the 
table</entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the 
table</entry></row><row><entry>table_type</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Type
 of table: BASE TABLE, VIEW, LOCAL TEMPORARY, SYSTEM TABLE, GLOBAL TEMPORARY, ALIAS or 
SYNONYM</entry></row><row><entry>is_insertable_into</entry><entry>boolean</entry><entry></entry><entry>Yes
 </entry>
 <entry>Tells if the table's contents can be 
modified</entry></row><row><entry>table_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>table_short_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>table_full_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>table_owner</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of catalog that contains the 
table</entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of schema that contains the 
table</entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the 
table</entry></row><row><entry>table_type</entry><entry>string</entry><entry/><entry>No</entry><entry>Type of 
table: BASE TABLE, VIEW, LOCAL TEMPORARY, SYSTEM TABLE, GLOBAL TEMPORARY, ALIAS or 
SYNONYM</entry></row><row><entry>is_insertable_into</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry

Tells i

 f the table's contents can be 
modified</entry></row><row><entry>table_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>table_short_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>table_full_name</entry><entry>text</entry><entry/><entry>No</entry><entry></entry></row><row><entry>table_owner</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -105,7 +105,7 @@ do not modify-->
   <sect3 id="is:_views">
     <title>_views table</title>
     <para>List of views and their specific information</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of catalog that contains the 
view</entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of schema that contains the 
view</entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the 
view</entry></row><row><entry>view_definition</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>View
 as 
SQL</entry></row><row><entry>check_option</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>CASCADE
 if the statement used to create the view included the WITH CHECK OPT
 ION; oth
 erwise, 
NONE</entry></row><row><entry>is_updatable</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry>Tells
 if the view's contents can be modified</entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of catalog that contains the 
view</entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of schema that contains the 
view</entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the 
view</entry></row><row><entry>view_definition</entry><entry>text</entry><entry/><entry>Yes</entry><entry>View 
as 
SQL</entry></row><row><entry>check_option</entry><entry>string</entry><entry/><entry>Yes</entry><entry>CASCADE
 if the statement used to create the view included the WITH CHECK OPTION; otherwise, 
 NONE</en
 try></row><row><entry>is_updatable</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry>Tells if 
the view's contents can be modified</entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -117,7 +117,7 @@ do not modify-->
   <sect3 id="is:_collations">
     <title>_collations table</title>
     <para>List of collations methods</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>collation_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>collation_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>collation_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>collation_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_short_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>collation_full_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row></tbody></tgroup></informalta
 ble></pa
 ra>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>collation_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>collation_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>collation_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>collation_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_short_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>collation_full_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -129,7 +129,7 @@ do not modify-->
   <sect3 id="is:_character_sets">
     <title>_character_sets table</title>
     <para>List of character sets</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>character_set_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>character_set_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>character_set_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>default_collate_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>default_collate_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>default_collate_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><e
 ntry>cha
 
racter_set_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_set_short_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>character_set_full_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>character_set_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>character_set_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>character_set_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>default_collate_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>default_collate_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>default_collate_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_co
 mments</
 
entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_short_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>character_set_full_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -144,7 +144,7 @@ do not modify-->
   <sect3 id="is:_routines">
     <title>_routines table</title>
     <para>List of functions and stored procedures (note: the primary jey for that table is composed of 
(specific_catalog, specific_schema, specific_name))</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Specific
 name of catalog that contains the 
routine</entry></row><row><entry>specific_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Specific
 name of schema that contains the 
routine</entry></row><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Specific
 name of the routine (may be mangled for polymorphic 
routines)</entry></row><row><entry>routine_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of catalog that contains the routine (may be NULL)</entry></row><row><entry>routine_schema</entry><ent
 ry>strin
 g</entry><entry></entry><entry>Yes</entry><entry>Name of schema that contains the routine (may be 
NULL)</entry></row><row><entry>routine_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Name
 of the 
routine</entry></row><row><entry>routine_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>FUNCTION,
 PROCEDURE, 
AGGREGATE</entry></row><row><entry>return_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Data
 type returned by the routine (may be NULL if routine does not return any 
value)</entry></row><row><entry>returns_set</entry><entry>boolean</entry><entry></entry><entry>No</entry><entry>True
 if routine returns a set (i.e., multiple values of the specified data type or if data type may 
vary)</entry></row><row><entry>nb_args</entry><entry>gint</entry><entry></entry><entry>No</entry><entry>Number
 of arguments (-1 for variable number of 
arguments)</entry></row><row><entry>routine_body</entry><entry>string</entry>
 <entry><
 /entry><entry>Yes</entry><entry>If the routine is an SQL function, then SQL, else 
EXTERNAL</entry></row><row><entry>routine_definition</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>The
 source text of the 
routine</entry></row><row><entry>external_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>If
 the routine is an external function, then the external name (link symbol) of the 
function</entry></row><row><entry>external_language</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>The
 language the routine is written 
in</entry></row><row><entry>parameter_style</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Parameter
 style (GENERAL, JAVA, SQL, GENERAL WITH 
NULLS)</entry></row><row><entry>is_deterministic</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry>Tells
 if the routine returns the same results given the same arguments 
forever</entry></row><row><entry>sql_data_access</entry><
 entry>st
 ring</entry><entry></entry><entry>Yes</entry><entry>Whether the routine contains SQL and whether it reads or 
modifies data (NONE, CONTAINS, READS, 
MODIFIES)</entry></row><row><entry>is_null_call</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry>Tells
 if the routine will be called if any one of its arguments is 
NULL</entry></row><row><entry>routine_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>routine_short_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>routine_full_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>routine_owner</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Specific
 name of catalog that contains the 
routine</entry></row><row><entry>specific_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Specific
 name of schema that contains the 
routine</entry></row><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Specific
 name of the routine (may be mangled for polymorphic 
routines)</entry></row><row><entry>routine_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of catalog that contains the routine (may be NULL)</entry></row><row><entry>routine_schema</entry><entry>stri
 ng</entr
 y><entry/><entry>Yes</entry><entry>Name of schema that contains the routine (may be 
NULL)</entry></row><row><entry>routine_name</entry><entry>string</entry><entry/><entry>No</entry><entry>Name 
of the 
routine</entry></row><row><entry>routine_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>FUNCTION,
 PROCEDURE, 
AGGREGATE</entry></row><row><entry>return_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Data
 type returned by the routine (may be NULL if routine does not return any 
value)</entry></row><row><entry>returns_set</entry><entry>boolean</entry><entry/><entry>No</entry><entry>True 
if routine returns a set (i.e., multiple values of the specified data type or if data type may 
vary)</entry></row><row><entry>nb_args</entry><entry>gint</entry><entry/><entry>No</entry><entry>Number of 
arguments (-1 for variable number of 
arguments)</entry></row><row><entry>routine_body</entry><entry>text</entry><entry/><entry>Yes</entry><entry>If
 the routine is 
 an SQL f
 unction, then SQL, else 
EXTERNAL</entry></row><row><entry>routine_definition</entry><entry>text</entry><entry/><entry>Yes</entry><entry>The
 source text of the 
routine</entry></row><row><entry>external_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry>If
 the routine is an external function, then the external name (link symbol) of the 
function</entry></row><row><entry>external_language</entry><entry>string</entry><entry/><entry>Yes</entry><entry>The
 language the routine is written 
in</entry></row><row><entry>parameter_style</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Parameter
 style (GENERAL, JAVA, SQL, GENERAL WITH 
NULLS)</entry></row><row><entry>is_deterministic</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry>Tells
 if the routine returns the same results given the same arguments 
forever</entry></row><row><entry>sql_data_access</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Whether
 the routine contains SQL and wheth
 er it re
 ads or modifies data (NONE, CONTAINS, READS, 
MODIFIES)</entry></row><row><entry>is_null_call</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry>Tells
 if the routine will be called if any one of its arguments is 
NULL</entry></row><row><entry>routine_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>routine_short_name</entry><entry>text</entry><entry/><entry>No</entry><entry></entry></row><row><entry>routine_full_name</entry><entry>text</entry><entry/><entry>No</entry><entry></entry></row><row><entry>routine_owner</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -156,7 +156,7 @@ do not modify-->
   <sect3 id="is:_triggers">
     <title>_triggers table</title>
     <para>List of triggers</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>trigger_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>trigger_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>trigger_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>event_manipulation</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Event
 that fires the trigger (INSERT, UPDATE, or 
DELETE)</entry></row><row><entry>event_object_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the database that contains the table that the trigger is defined on</entry></row><row><entry>
 event_ob
 ject_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name of the schema that 
contains the table that the trigger is defined 
on</entry></row><row><entry>event_object_table</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the table that the trigger is defined 
on</entry></row><row><entry>action_statement</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Statement
 that is executed by the 
trigger</entry></row><row><entry>action_orientation</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Identifies
 whether the trigger fires once for each processed row or once for each statement (ROW or 
STATEMENT)</entry></row><row><entry>condition_timing</entry><entry>string</entry><entry></entry><entry>No</entry><entry>Time
 at which the trigger fires (BEFORE or 
AFTER)</entry></row><row><entry>trigger_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>t
 rigger_s
 
hort_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>trigger_full_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>trigger_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>trigger_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>trigger_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>event_manipulation</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Event
 that fires the trigger (INSERT, UPDATE, or 
DELETE)</entry></row><row><entry>event_object_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the database that contains the table that the trigger is defined on</entry></row><row><entry>
 event_ob
 ject_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name of the schema that 
contains the table that the trigger is defined 
on</entry></row><row><entry>event_object_table</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry>Name
 of the table that the trigger is defined 
on</entry></row><row><entry>action_statement</entry><entry>text</entry><entry/><entry>Yes</entry><entry>Statement
 that is executed by the 
trigger</entry></row><row><entry>action_orientation</entry><entry>string</entry><entry/><entry>No</entry><entry>Identifies
 whether the trigger fires once for each processed row or once for each statement (ROW or 
STATEMENT)</entry></row><row><entry>condition_timing</entry><entry>string</entry><entry/><entry>No</entry><entry>Time
 at which the trigger fires (BEFORE or 
AFTER)</entry></row><row><entry>trigger_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>trigger_short_name</entry><entry>
 string</
 
entry><entry/><entry>No</entry><entry></entry></row><row><entry>trigger_full_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -171,7 +171,7 @@ do not modify-->
   <sect3 id="is:_columns">
     <title>_columns table</title>
     <para>List of columns composing tables</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry></entry><entry>No</entry><entry>Column
 position, starts at 
1</entry></row><row><entry>column_default</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>is_nullable</ent
 ry><entr
 
y>boolean</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>data_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Data
 type of the column (if the column is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Array
 description if the column is an 
array</entry></row><row><entry>gtype</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>character_maximum_length</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_octet_length</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>numeric_precision</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry>If
 data_type identifies a numeric type, this column contains the precision of the type for this column (the 
number of significant digits)</en
 try></ro
 w><row><entry>numeric_scale</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry>If data_type 
identifies an exact numeric type, this column contains the scale of the type for this column (the number of 
significant digits to the right of the decimal 
point)</entry></row><row><entry>datetime_precision</entry><entry>gint</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_set_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_set_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>character_set_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>collation_name</e
 ntry><en
 
try>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>extra</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>CSV
 string with: 
AUTO_INCREMENT</entry></row><row><entry>is_updatable</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>column_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry/><entry>No</entry><entry>Column
 position, starts at 
1</entry></row><row><entry>column_default</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>is_nullable</entry><entry>bool
 ean</ent
 
ry><entry/><entry>No</entry><entry></entry></row><row><entry>data_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Data
 type of the column (if the column is an array, then 'array_spec' is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Array 
description if the column is an 
array</entry></row><row><entry>gtype</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>character_maximum_length</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_octet_length</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>numeric_precision</entry><entry>gint</entry><entry/><entry>Yes</entry><entry>If
 data_type identifies a numeric type, this column contains the precision of the type for this column (the 
number of significant digits)</entry></row><row><entry>numeric_scale</entry><entry>gint</entry><
 entry/><
 entry>Yes</entry><entry>If data_type identifies an exact numeric type, this column contains the scale of the 
type for this column (the number of significant digits to the right of the decimal 
point)</entry></row><row><entry>datetime_precision</entry><entry>gint</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>character_set_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>collation_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>extra</entry><entry>string<
 /entry><
 entry/><entry>Yes</entry><entry>CSV string with: 
AUTO_INCREMENT</entry></row><row><entry>is_updatable</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>column_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -192,7 +192,7 @@ do not modify-->
   <sect3 id="is:_table_constraints">
     <title>_table_constraints table</title>
     <para>List of constraints applied to tables (Check, primary or foreign key, or unique constraints)</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>constraint_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the catalog that contains the 
constraint</entry></row><row><entry>constraint_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the schema that contains the 
constraint</entry></row><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entr
 y>Yes</e
 
ntry><entry>No</entry><entry></entry></row><row><entry>constraint_type</entry><entry>string</entry><entry></entry><entry>No</entry><entry>CHECK,
 FOREIGN KEY, PRIMARY KEY or 
UNIQUE</entry></row><row><entry>check_clause</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>The
 check expression if the constraint is a check constraint, NULL 
otherwise</entry></row><row><entry>is_deferrable</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>initially_deferred</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>constraint_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the catalog that contains the 
constraint</entry></row><row><entry>constraint_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the schema that contains the 
constraint</entry></row><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><
 entry>No
 
</entry><entry></entry></row><row><entry>constraint_type</entry><entry>string</entry><entry/><entry>No</entry><entry>CHECK,
 FOREIGN KEY, PRIMARY KEY or 
UNIQUE</entry></row><row><entry>check_clause</entry><entry>text</entry><entry/><entry>Yes</entry><entry>The 
check expression if the constraint is a check constraint, NULL 
otherwise</entry></row><row><entry>is_deferrable</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>initially_deferred</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -204,7 +204,7 @@ do not modify-->
   <sect3 id="is:_referential_constraints">
     <title>_referential_constraints table</title>
     <para>List of foreign key constraints, along with some specific attributes</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_catalog</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>ref_table_schema</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>ref_table_name</entry><entry>string<
 /entry><
 
entry></entry><entry>No</entry><entry></entry></row><row><entry>ref_constraint_name</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>match_option</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>FULL,
 PARTIAL or 
NONE</entry></row><row><entry>update_rule</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>CASCADE,
 SET NULL, SET DEFAULT, RESTRICT, NO ACTION or 
NONE</entry></row><row><entry>delete_rule</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>CASCADE,
 SET NULL, SET DEFAULT, RESTRICT, NO ACTION or NONE</entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_catalog</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>ref_table_schema</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>ref_table_name</entry><entry>string</entry><entry/

<entry>

 
No</entry><entry></entry></row><row><entry>ref_constraint_name</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>match_option</entry><entry>string</entry><entry/><entry>Yes</entry><entry>FULL,
 PARTIAL or 
NONE</entry></row><row><entry>update_rule</entry><entry>string</entry><entry/><entry>Yes</entry><entry>CASCADE,
 SET NULL, SET DEFAULT, RESTRICT, NO ACTION or 
NONE</entry></row><row><entry>delete_rule</entry><entry>string</entry><entry/><entry>Yes</entry><entry>CASCADE,
 SET NULL, SET DEFAULT, RESTRICT, NO ACTION or NONE</entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -234,7 +234,7 @@ do not modify-->
   <sect3 id="is:__declared_fk">
     <title>__declared_fk table</title>
     <para>List of foreign key constraints, declared in Libgda and unknown to the database</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_schema</entry><entry>stri
 ng</entr
 
y><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ts</entry><entry>timestamp</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>descr</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_schema</entry><entry>stri
 ng</entr
 
y><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ref_column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ts</entry><entry>timestamp</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>descr</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
   </sect3>
   <sect3 id="is:_check_column_usage">
     <title>_check_column_usage table</title>
@@ -269,7 +269,7 @@ do not modify-->
   <sect3 id="is:_domain_constraints">
     <title>_domain_constraints table</title>
     <para>List of constraints applicable to domains</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>constraint_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the catalog that contains the 
constraint</entry></row><row><entry>constraint_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the schema that contains the 
constraint</entry></row><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>domain_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>domain_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>domain_name</entry><entry>string</entry><e
 ntry>Yes
 
</entry><entry>No</entry><entry></entry></row><row><entry>check_clause</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>is_deferrable</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>initially_deferred</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>constraint_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the catalog that contains the 
constraint</entry></row><row><entry>constraint_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the schema that contains the 
constraint</entry></row><row><entry>constraint_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>domain_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>domain_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>domain_name</entry><entry>string</entry><entry>Yes</entr
 y><entry

No</entry><entry></entry></row><row><entry>check_clause</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>is_deferrable</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>initially_deferred</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>

     <para>
       <itemizedlist>
         <listitem>
@@ -284,7 +284,7 @@ do not modify-->
   <sect3 id="is:_parameters">
     <title>_parameters table</title>
     <para>List of routines' (functions and stored procedures) parameters (may not contain data for some 
routines which accept any type of parameter)</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>parameter_mode</entry><entry>string</entry><entry></entry><entry>No</entry><entry></entry></row><row><entry>parameter_name</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>data_type</entry><entry>string</
 entry><e
 ntry></entry><entry>Yes</entry><entry>Data type of the parameter (if the parameter is an array, then 
'array_spec' is set, and this may be NULL; can also be NULL if any type of parameter is 
accepted)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Array
 description if the parameter is an array</entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>parameter_mode</entry><entry>string</entry><entry/><entry>No</entry><entry></entry></row><row><entry>parameter_name</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>data_type</entry><entry>string</entry><entry/>
 <entry>Y
 es</entry><entry>Data type of the parameter (if the parameter is an array, then 'array_spec' is set, and 
this may be NULL; can also be NULL if any type of parameter is 
accepted)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Array
 description if the parameter is an array</entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -299,7 +299,7 @@ do not modify-->
   <sect3 id="is:_routine_columns">
     <title>_routine_columns table</title>
     <para>List of routines' (functions and stored procedures) returned values' parts (columns) for routines 
returning composed values</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry>Yes</entry><entry>Yes</entry><entry></entry></row><row><entry>data_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Data
 type of the column (if the column is an array, then 'arra
 y_spec' 
 is set, and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Array
 description if the column is an array</entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>specific_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>specific_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry>Yes</entry><entry>Yes</entry><entry></entry></row><row><entry>data_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Data
 type of the column (if the column is an array, then 'array_spec'
  is set,
  and this may be 
NULL)</entry></row><row><entry>array_spec</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Array 
description if the column is an array</entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -314,7 +314,7 @@ do not modify-->
   <sect3 id="is:_table_indexes">
     <title>_table_indexes table</title>
     <para>List of tables' indexes which do not relate to primary keys</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>index_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the catalog that contains the 
index</entry></row><row><entry>index_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Name
 of the schema that contains the 
index</entry></row><row><entry>index_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</e
 ntry><en
 
try></entry></row><row><entry>is_unique</entry><entry>boolean</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>index_def</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Index
 
definition</entry></row><row><entry>index_type</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>Database
 specific type of index such as BTREE, 
...</entry></row><row><entry>extra</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry>CSV 
string with: ASCENDING, 
...</entry></row><row><entry>index_owner</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>index_comments</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>index_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name
 of the catalog that contains the 
index</entry></row><row><entry>index_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Name 
of the schema that contains the 
index</entry></row><row><entry>index_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></
 entry></
 
row><row><entry>is_unique</entry><entry>boolean</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>index_def</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Index
 
definition</entry></row><row><entry>index_type</entry><entry>string</entry><entry/><entry>Yes</entry><entry>Database
 specific type of index such as BTREE, 
...</entry></row><row><entry>extra</entry><entry>string</entry><entry/><entry>Yes</entry><entry>CSV string 
with: ASCENDING, 
...</entry></row><row><entry>index_owner</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>index_comments</entry><entry>text</entry><entry/><entry>Yes</entry><entry></entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
@@ -326,7 +326,7 @@ do not modify-->
   <sect3 id="is:_index_column_usage">
     <title>_index_column_usage table</title>
     <para>List of the tables' columns involved in an index listed in the _table_indexes table</para>
-    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>index_catalog</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>index_schema</entry><entry>string</entry><entry></entry><entry>Yes</entry><entry></entry></row><row><entry>index_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>
 Yes</ent
 
ry><entry>Yes</entry><entry></entry></row><row><entry>column_expr</entry><entry>string</entry><entry>Yes</entry><entry>Yes</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry></entry><entry>No</entry><entry>Column
 position in the index, starts at 1</entry></row></tbody></tgroup></informaltable></para>
+    <para>The following table describes the columns:<informaltable frame="all"><tgroup cols="5" colsep="1" 
rowsep="1" align="justify"><thead><row><entry>Column 
name</entry><entry>Type</entry><entry>Key</entry><entry>Can be 
NULL</entry><entry>description</entry></row></thead><tbody><row><entry>index_catalog</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>index_schema</entry><entry>string</entry><entry/><entry>Yes</entry><entry></entry></row><row><entry>index_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_catalog</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_schema</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>table_name</entry><entry>string</entry><entry>Yes</entry><entry>No</entry><entry></entry></row><row><entry>column_name</entry><entry>string</entry><entry>Yes</entry><en
 try>Yes<
 
/entry><entry></entry></row><row><entry>column_expr</entry><entry>string</entry><entry>Yes</entry><entry>Yes</entry><entry></entry></row><row><entry>ordinal_position</entry><entry>gint</entry><entry/><entry>No</entry><entry>Column
 position in the index, starts at 1</entry></row></tbody></tgroup></informaltable></para>
     <para>
       <itemizedlist>
         <listitem>
diff --git a/libgda/gda-meta-store.c b/libgda/gda-meta-store.c
index bf973906f..6c525a299 100644
--- a/libgda/gda-meta-store.c
+++ b/libgda/gda-meta-store.c
@@ -37,8 +37,9 @@
  *      version 2 for libgda >= 4.1.4: added the "_table_indexes" and "_index_column_usage" tables
  *      version 3 for libgda >= 4.2.4: added the "__declared_fk" table
  *      version 4 for libgda >= 5.2.0: added "schema_default" to "_schemata" table
+ *      version 5 for libgda >= 6.0: changed columns types to use TEXT types
  */
-#define CURRENT_SCHEMA_VERSION "4"
+#define CURRENT_SCHEMA_VERSION "5"
 
 #include <string.h>
 #include <glib/gi18n-lib.h>
diff --git a/tools/misc/information-schema-types.c b/tools/misc/information-schema-types.c
index 23839c0cd..c31b67cb5 100644
--- a/tools/misc/information-schema-types.c
+++ b/tools/misc/information-schema-types.c
@@ -125,7 +125,7 @@ main (G_GNUC_UNUSED int argc, G_GNUC_UNUSED char** argv)
                                                        g_string_append (tmp_out_types_str, "G_TYPE_BOOLEAN");
                                                else if (type == G_TYPE_INT)
                                                        g_string_append (tmp_out_types_str, "G_TYPE_INT");
-                                               else if (type == G_TYPE_DATE_TIME) {
+                                               else if (type == G_TYPE_DATE_TIME || type == GDA_TYPE_TEXT) {
                                                        xmlChar *tname;
                                                        tname = xmlGetProp (node, BAD_CAST "name");
                                                        g_print ("Warning: ignoring table %s because the '%s' 
type is "

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]