Maximum Length of Some Object Names Increased
The maximum length of all object names in Ingres versions prior to 10.0 was 32 bytes. Ingres 10.0 introduced support for long identifiers, also called long object names.
To match Ingres 10.0, the maximum supported length of some object names was increased to 256 bytes in Enterprise Access and OpenSQL. The system catalog iidbcapabilities now reports the maximum length of object names for the host DBMS.
Names for the following objects are now a maximum of 256 bytes:
• Table
• Column
• Partition
• Procedure
• Procedure parameter
• Rule
• Sequence
• Synonym
• Constraint
The maximum length of names for the following objects remains at 32 bytes:
• Database
• User, owner, group, role, schema
• Location
• Event, alarm
• Profile
• Node
• Password
For more information, see "Object Name Length" and "Table and Column ID Length" in the Developing Portable Applications Guide.