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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
