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