Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign Key written as a trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Foreign Key written as a trigger
Date
Msg-id 8197.1121091438@sss.pgh.pa.us
Whole thread Raw
In response to Foreign Key written as a trigger  ("George Woodring" <george.woodring@iglass.net>)
List pgsql-general
Tree view 
"George Woodring" <george.woodring@iglass.net> writes:
> I have a database that has been upgrade numerous times (Started about
> 7.1 and is not 7.4.8).  The table has 2 foreign keys on it, but when I
> look at the table I see that the FK applied before 7.4.X is written as a
> trigger.  Everything seems to work, I was just wondering if there are
> any performance reasons to change the trigger to a FK.

I don't think it would have any performance impact, but it'd definitely
be more future-proof to hide the triggers.  See contrib/adddepend for
a possibly helpful tool.

            regards, tom lane

pgsql-general by date:

Previous
From: "George Woodring"
Date:
Subject: Foreign Key written as a trigger
Next
From: Alvaro Herrera
Date:
Subject: Re: Transaction isolation levels