Deferred Constraints

Possible in several databases, not not standardised. Useful because it lets you write complex structures without having to worry about maintaining referential integrity at every operation - it all gets checked in one big bang at commit. Not necessarily what you'd always want, but useful to be able to do.

Oracle - options are a bit complex.

PostgreSQL - FK only, so not, eg, uniques (?).