"Dave Page" <[EMAIL PROTECTED]> writes: > Thing is Tom, this issue can be reproduced *every* time, without fail.
And have you vacuumed or analyzed yet? Or possibly you are short an index or two (you really need indexes on both the referencing and referenced columns). > I've been looking at his for some time now (couple of weeks or more), > and the only thing I can find is the SELECT ... FOR UPDATE in the > PostgreSQL logs that I quoted. These exactly follow *every* fkey > creation, and are definately not issued by pgAdmin. No, I told you: those are the internal verification query (it comes from RI_FKey_check_ins(), if you want to look). If you really think the schema qualification has something to do with it, try issuing the ADD FOREIGN KEY command manually in psql, with and without schema name. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster