Re: Tweaking Foreign Keys for larger tables

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