Re: Foreign Key written as a trigger

"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