Adding a New Composite Constraint to an Existing Table.

From: Bhuvan A <bhuvansql(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Adding a New Composite Constraint to an Existing Table.
Date: 2002-02-09 10:28:38
Message-ID: Pine.LNX.4.20.0202091548400.8097-100000@Larry.bks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

I am using postgresql 7.1. I was unable to add a new PRIMARY KEY
constraint to an existing table.

i have table,
CREATE TABLE xx
(
id int,
name text,
amount int
);

I have say some 10 records in this table, which are unique and not
null (primary). Fine! Now, i am willing to have primary key constraint
to all the 3 fields.

I tried,

bhuvan=> ALTER TABLE xx ADD primary key (id, name, amount);
ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented for that
constraint type.

Where i am wrong? How else, can i get that primary key constraint
WITHOUT RECREATING that table?

Hope to get some lights.

Regards,
Bhuvaneswar.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message MindTerm 2002-02-09 12:57:33 Re: Adding a New Composite Constraint to an Existing Table.
Previous Message Bruce Momjian 2002-02-08 14:02:26 Re: Multiprocessor support for 7.2