The system_maintained Column Name
Databases created prior to Ingres II 2.5 may contain the system catalog ii_atttype, which has a column named SYSTEM_MAINTAINED. As of Ingres II 2.5 SYSTEM_MAINTAINED becomes a reserved word. At Ingres II 2.5, the column name SYSTEM_MAINTAINED was changed to SYS_MAINTAINED.
Loading a database that contains ii_atttype into version 2.5 will fail. Loading into Ingres II 2.6 and higher does not have the problem because they use a context sensitive keyword parser.
For reload to work with Ingres II 2.5, it is necessary to edit the copy.in script changing the column name in ii_attype from SYSTEM_MAINTAINED to SYS_MAINTAINED.
While this change can be made using a utility such as sed, beware of inadvertently changing the keyword SYSTEM_MAINTAINED in other places within copy.in.
Last modified date: 08/29/2024