Informix Error -19826: Cannot create INSTEAD OF trigger for a select event.
Cause and resolution
Cannot create INSTEAD OF trigger for a select event.
You can create an INSTEAD OF trigger for an insert, update, or delete event, but not for a select event.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-19826 fires when CREATE TRIGGER ... INSTEAD OF SELECT is attempted — per the official
guidance. INSTEAD OF triggers can only be created for insert, update, or delete events.
INSTEAD OFspecified for aSELECTevent, per the official guidance — the direct, only cause.
Solutions / Resolution
- Create the
INSTEAD OFtrigger for an insert, update, or delete event instead, per the official guidance.
Examples
An INSTEAD OF trigger on SELECT
CREATE TRIGGER mytrig INSTEAD OF SELECT ON myview ...
Corrected
CREATE TRIGGER mytrig INSTEAD OF INSERT ON myview ...
Diagnostic Checks
- Check the
CREATE TRIGGERstatement's event, and useINSERT/UPDATE/DELETEinstead ofSELECT.
Related Errors / Related Topics
- -19827 — "Cannot create an INSTEAD OF trigger on a table." A related
INSTEAD OFrestriction, about the target object rather than the triggering event.
INSTEAD OF triggers can't be created for SELECT — use INSERT/UPDATE/DELETE.