If the parent table in foreign key constraint is not in your own schema you have to have REFERENCES privilege on that table granted by it's owner. Unfortunately there is no appropriate system privilege for that (something like REFERENCES ANY TABLE), so you have to get REFERENCES privilege directly from that user for each table you want to referenc in your FK constraints. BTW, REFERENCES privilege can be limited on a particular column(s) if the owner does not want to grant it on a whole table.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?