Re: references table(multiple columns go here) - Mailing list pgsql-sql

Tom Lane wrote:

> Gary Stainburn  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...

That's right. The letter has gone somewhere...
Tomasz Myrta