primary key - Mailing list pgsql-general

From Andrea Antibo
Subject primary key
Date
Msg-id XFMail.980909163532.antibo@mclink.it
Whole thread Raw
Responses Re: [GENERAL] primary key
List pgsql-general
I trust this query on postgresql 6.2.x



CREATE TABLE films (
       code      CHARACTER(5) CONSTRAINT firstkey PRIMARY KEY,
       title     CHARACTER VARYING(40) NOT NULL,
       did      DECIMAL(3) NOT NULL,
       date_prod DATE,
       kind     CHAR(10),
       len       INTERVAL HOUR TO MINUTE     );


but I have error near CONSTRAINT.

Maybe this version of postgres can't accept the primary key?


pgsql-general by date:

Previous
From: Jim Jennis
Date:
Subject: Using a delimited Ascii File to initialize fields and array elements in bulk
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] primary key