Multiple References on one Foreign Key

I hope this is the right place to ask this question. I've search the archives
the news groups and could not find anything so I apologize if this has been
answered previously.

Here is my sample table:

CREATE TABLE master2 (
id int primary key,
name varchar(32),
nickname varchar(32),
unique (name,nickname)
);

This issue is this:

create table reftest2 (
id int primary key,
invited varchar(32),
foreign key (invited) references master2 (name,nickname) on update
cascade on d
elete
cascade
);

This produces the following message:

"ERROR: CREATE TABLE: number of referencing and referenced attributes
for
foreign key disagree"

The idea is that I want to have invited in reftest2 be constrainted
against name
and nickname in the master2 table (actually I really don't want to
"unique
(name,nickname)" in master2, I'd rather have name and nickname be
unique within
themselves if possible)

Is this possible?

--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com