Object Management Extension Restrictions
The following restrictions apply to Object Management Extension:
• You can add a maximum of 128 new data types.
• You cannot export user-defined data types from the DBMS Server.
For this reason, the Ingres user interfaces (such as Query-By-Forms or Report-By-Forms) cannot manipulate user-defined data types in their “natural” state. You must choose a standard SQL data type to represent the new data types for the user interface programs and write the necessary coercion routines.
Note: The copy statement allows the byte representation of the data to be exported. However, copy handles this data as char. To avoid errors caused by network character translation, avoid moving the data to a different machine using Ingres Net.