"George Woodring" <george.woodring@xxxxxxxxxx> 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
