Re: references table(multiple columns go here)

Gary Stainburn <gary.stainburn@ringways.co.uk> writes:
> I've just tried this on a 7.2.1-5 system and get the same error.

>> create table jobtypes (
>> jid         int4 default nextval('jobs_jid_seq'::text) unique not null,
>> jdid        character,        -- This joint reference
>> jrank        int4 not null references ranks(rrank),    -- needs sorting
>> jdesc        character varying(40),    -- job description
>> contraint c2 foreign key (jdid,jrank) references ranks (rdid,rrank)  ^^^^^^^^^
>> );
>> ERROR:  parser: parse error at or near "foreign"

If that's an accurate transcription, I think "contraint" -> "constraint"
would help...
        regards, tom lane