Re: [GENERAL] primary key

Ciao Andrea,

mercoledì, 9 settembre 98, you wrote:

AA> I trust this query on postgresql 6.2.x



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


AA> but I have error near CONSTRAINT.

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


PostgreSQL 6.2 hasn't this feature, you need v-6.3.2.


Best regards,
  Jose'                            mailto:sferac@bo.nettuno.it