From: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, Andrea Antibo <antibo(at)mclink(dot)it> |
Subject: | Re: [GENERAL] primary key |
Date: | 1998-09-09 15:29:27 |
Message-ID: | 15728.980909@bo.nettuno.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)bo(dot)nettuno(dot)it
From | Date | Subject | |
---|---|---|---|
Next Message | John Smith | 1998-09-10 05:20:48 | suggestions on vacuum |
Previous Message | Herouth Maoz | 1998-09-09 15:04:53 | Re: [GENERAL] primary key |