On 11/6/14, 11:49 AM, David G Johnston wrote:
> > Constraint would add a statement-level after trigger for insert,
> > update, delete and trigger, which issues a relcache invalidation if
> > the state was marked valid. Marked as deferrable initially deferred.
> I don't think you'd need to invalidate on insert,
>
>
> Why? Since the FK is not enforced there is no guarantee that what you just inserted is valid
I'm talking about the referenced (aka 'parent') table, not the referring table.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com