Adding PostgreSQL PRIMARY KEY - help

[alta <al...@al...>]

I sometimes get duplicate records, for example when creating a 
customer.  I know this should not happen, but it does.

To eliminate this problem, I have tried to add a PRIMARY KEY with 
psql.  Here's how:

    alter table customer add constraint cs1 primary key(id);

But, I get this error:

"ERROR:  ALTER TABLE / ADD CONSTRAINT is not implemented for that 
constraint type."

According to documentation (PostgreSQL Essential Reference), the ADD 
CONSTRAINT command is supported.

Other than saving data, deleting the table, re-creating the table 
with the primary key, and restoring data, is there an easy to add a 
primary key (that works)?

... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...