> > I finally found more time to test this more extensively. i'm still > > running into an issue with this, although it's different this time. > > There are no errors printed to the terminal, but neither the foreign > > key nor the trigger get made. > > It looks like you are trying to restore from a selective dump (-t > switch) that includes only one of the two tables involved in the FK > constraint. The backend logic for converting triggers to proper FK > constraints can only work if it sees both tables (and their triggers) > created during a single session. I see what you're saying, but the weird thing is that this happened even when I did a full dump/restore of that database. I'll try out a few different things (like restoring the tables, then restoring the triggers). Hopefully I'll be able to suss out the issue or at least find a workaround. Peter ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
