Gary Stainburn <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
