Postgres Pro
Downloads
Home   >   mailing lists

Re: Constraint Trigger's referenced_table - Mailing list pgsql-general

From Tom Lane
Subject Re: Constraint Trigger's referenced_table
Date
Msg-id 27863.1198359965@sss.pgh.pa.us
Whole thread Raw
In response to Re: Constraint Trigger's referenced_table  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: Constraint Trigger's referenced_table
Re: Constraint Trigger's referenced_table
List pgsql-general
Tree view 
Richard Broersma Jr <rabroersma@yahoo.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

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Constraint Trigger's referenced_table
Next
From: Richard Broersma Jr
Date:
Subject: Re: Constraint Trigger's referenced_table