Try this create table FOOS( opaque_id int4 NOT NULL PRIMARY KEY, name text NOT NULL, bars int4 NOT NULL, bazs int4 NOT NULL ); or this create table FOOS( opaque_id int4 NOT NULL, name text NOT NULL, bars int4 NOT NULL, bazs int4 NOT NULL, CONSTRAINT opaque_key PRIMARY KEY (opaque_id) ); -Margarita On Thu, 8 Apr 1999, Todd Graham Lewis wrote: > My inference based on this email, namely that foreign keys are in some > at-least-minimal way supported or will be soon, is given the lie on my > compile today out of CVS: > > > tlewis=> create table FOOS( > opaque_id int4 NOT NULL, > name text NOT NULL, > bars int4 NOT NULL, > bazs int4 NOT NULL) > PRIMARY KEY (opaque_id); > ERROR: parser: parse error at or near "primary" > > tlewis=> \h create table > Command: create table > Description: create a new table > Syntax: > CREATE [TEMP] TABLE class_name > (attr1 type1 [DEFAULT expression] [NOT NULL], ...attrN > [[CONSTRAINT name] CHECK condition1, ...conditionN] ) > [INHERITS (class_name1, ...class_nameN) > ; > > So, Brunhilda, what's the magin incantation? Do I need some tail > of Newt? 8^) >