7.1 REFERENCES contstraints

I see that the REFERENCES constraint is a little more restrictive in 
7.1. I need to have a table with a constraint so one of it's columns 
must exist in a second table. This is not a key, since there may be N 
columns in the second table that match. Any ideas on how I should 
create this?

CREATE table foo(
id serial,
permissions int4,
FOREIGN KEY (permissions) REFERENCES bar(permid));

used to work in 7.0 but now it complains with:
psql:ddl.sql:103: ERROR:  UNIQUE constraint matching given keys for 
referenced table "permissions" not found

-Michael
_________________________________________________________________    http://fastmail.ca/ - Fast Free Web Email for
Canadians