Re: Foreign key wierdness

"Dave Page" <dpage@vale-housing.co.uk> 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