Alter table Add Primary Key
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@ptinovacao.pt
Ola Ana Claudia.
You can add a primary key to your table using:
CREATE INDEX ...command
I hope this help you.
Jos� Soares
Show quoted text
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 MESSAGESExample:
/*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�udiaAna Cl�udia Dias
Aveiro - PortugalEmail: ana-b-dias@ptinovacao.pt
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?