Alter table Add Primary Key

From: Ana Claudia <ana-b-dias(at)ptinovacao(dot)pt>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Alter table Add Primary Key
Date: 2001-10-01 18:35:21
Message-ID: 25CCC6566D01D411885B00A024559FB7011FE072@EXCHANGE_GERAL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'd like to know if is possible create a primary key in a table that already
exits in database (note: in Oracle is possible), because I try do that and I
received an ERROR MESSAGES

Example:
/*Script taht I used to create the table*/
CREATE TABLE tespri
(
pri NUMERIC(3,0) NOT NULL CHECK (pri between 0 and 255),
sec VARCHAR(4) NOT NULL CHECK (sec<> 'ana')
);

/* End of Script */

teste=# \d tespri
Table "tespri"
Attribute | Type | Modifier
-----------+----------------------+----------
pri | numeric(3,0) | not null
sec | character varying(4) | not null
Constraints: ((pri >= '0'::"numeric") AND (pri <= '255'::"numeric"))
(sec <> 'ana'::"varchar")

teste=# alter table tespri add constraint ck1 PRIMARY KEY(pri);
ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented for that constraint
type.
teste=#

/* NOTE: database name teste table name tespri */

Thanks for everything.
Best Regards,
Cláudia

Ana Cláudia Dias
Aveiro - Portugal

Email: ana-b-dias(at)ptinovacao(dot)pt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rdack 2001-10-01 18:48:31 pypgsql 'create database' problem
Previous Message R Talbot 2001-10-01 17:21:24 Perl and PostgreSQL 7.1.2 a DBI Connection