Re: Constraint Trigger's referenced_table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Constraint Trigger's referenced_table
Date: 2007-12-22 21:46:05
Message-ID: 27863.1198359965@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Broersma Jr <rabroersma(at)yahoo(dot)com> writes:
> So is the purpose of knowing the reference_table OID, is that it helps to generalize the logic of the CONSTRAINT TRIGGERS?

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2007-12-22 22:00:08 Re: Constraint Trigger's referenced_table
Previous Message Richard Broersma Jr 2007-12-22 21:42:50 Re: Constraint Trigger's referenced_table