"George Woodring" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to