Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E35D9475D0D for ; Wed, 18 Dec 2002 13:15:05 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 09753475AE6 for ; Wed, 18 Dec 2002 13:15:04 -0500 (EST) Received: from klaster.net (pt107.krakow.cvx.ppp.tpnet.pl [217.99.216.107]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 3DD5C2B2AE; Wed, 18 Dec 2002 18:58:36 +0100 (CET) Message-ID: <3E00BBC5.6040505@klaster.net> Date: Wed, 18 Dec 2002 19:17:41 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:1.2b) Gecko/20021016 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Gary Stainburn , pgsql-sql@postgresql.org Subject: Re: references table(multiple columns go here) References: <200212181625.11316.gary.stainburn@ringways.co.uk> <3E00A678.5070605@klaster.net> <200212181656.13432.gary.stainburn@ringways.co.uk> <200212181718.42870.gary.stainburn@ringways.co.uk> <8026.1040233829@sss.pgh.pa.us> In-Reply-To: <200212181625.11316.gary.stainburn@ringways.co.uk> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/230 X-Sequence-Number: 10818 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