Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> --- On Sat, 12/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>> No, the purpose is to support foreign-key triggers. FK constraints are
>> implemented via cooperating triggers on the two tables, and
>> each trigger has to be able to look at the other table.
> When you say "each trigger has to be able to look" do you mean that each
> trigger needs to be notified when other table has records that are
> inserted/updated/deleted?
No, each trigger fires for events in its own table. It then has to go
look at the other table to see if the FK constraint holds (and,
depending on which trigger you are talking about, perhaps make it hold
by changing the other table).
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
