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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
