Postgres Pro
Downloads
Home   >   mailing lists

Re: foreign keys and RI triggers - Mailing list pgsql-hackers

From Neil Conway
Subject Re: foreign keys and RI triggers
Date
Msg-id 4296B2AD.2040406@samurai.com
Whole thread Raw
In response to Re: foreign keys and RI triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: foreign keys and RI triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Tom Lane wrote:
> But the check could incorporate the same transaction ID test already
> in use.  I think Neil is right that it'd be a win to apply the test
> before enqueueing the trigger instead of after.

Speaking of which, does anyone see a reason why RI_FKey_keyequal_upd() 
is implemented as a pseudo-trigger function -- e.g. taking a pointer to 
a TriggerData? It seems a kludge.

-Neil

pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: unsafe use of hash_search(... HASH_ENTER ...)
Next
From: Hans-Jürgen Schönig
Date:
Subject: Re: WAL replay failure after file truncation(?)