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^)
>
