Triggers, Constraints & Referential Integrity

Triggers, constraints and referential integrity in Informix. Threads cover foreign-key and check constraints, trigger behaviour, and the errors raised when data violates a rule.

781 threads, 1992–2026.

Re: datatype for string

AUTO_CKPTS=Off when started and no checkpoints at all during a day???

Problems when adding foreign keys

Re: Onload, the "fast" alternative

Re: Purpose and effect of $DBNLS env

ISM - run backups as a user other than root?

Functional Index & sizing

Alarm for New virtual shared memory segment

Re: Alarm for New virtual shared memory segment

RE: New Informix packaging and, presumably, pricing

Foreign keys referring table in other database

RE: CRCOLS and VERCOLS and REPLCHECK

RE: Copy Table Schema ?

Looking for ESQL/C Multithreaded Source Code Example

Re: A teensy-weensy little oversight in the QA suite?

Re: how to use a trigger to stop an insert/update?

how to use a trigger to stop an insert/update?

Re: trigger on insert: updating one value of the same table

RE: Long Checkpoints IDS 11.50

trigger on insert: updating one value of the same table

Re: Need enlightenment regarding long transactions

Re: Protecting triggers?

Simple trigger question

Trigger problems

observations when testing V11.50.UC4

Re: Writing into Files from Stored Procedures

Writing into Files from Stored Procedures

Re: Auditing

Re: Genero DB

update trigger

temp spaces filling up

Re: Programming Informix 4GL: wait for event

ER Error Enterprise Replication

IDS 11 problem

trigger on multiple databases

Fwd: IIUG 2008 survey for new features

Unix Environment values from SPL/UDR

Re: Unix Environment values from SPL/UDR

Re: Weird one

triggering in 7.31

Trigger and replication

Re: INSERT TRIGGER

Re: Can Disk mirroring/db snapshots replace the usage oftaking database backups?

Re: Can Disk mirroring/db snapshots replace the usage of taking database backups?