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