Informix Error -26478: Can not add ERKEY when table already has ERKEY
Cause and resolution
Can not add ERKEY when table already has ERKEY
You attempted to alter a table to include the ERKEY attribute when that table already had the ERKEY attribute.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26478 fires when ALTER TABLE adds ERKEY to a table that already has it — per the
official guidance.
- The table already has the
ERKEYattribute, per the official guidance — the direct, only cause.
Solutions / Resolution
- Don't re-add
ERKEYto a table that already has it, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond re-adding ERKEY.
Diagnostic Checks
- Check whether the table already has
ERKEY, and skip theALTER TABLE ADDif so.
Related Errors / Related Topics
- -26477 — "Illegal usage of ERKEY" The general
ERKEY-usage restriction this is a specific instance of. - -26479 — "Can not drop ERKEY when table does not have ERKEY" The mirror-image
error, on dropping
ERKEYthat isn't present rather than adding one that already is.
ERKEY was added to a table that already has it — skip the ALTER TABLE.