SQL Error on PostgreSQL!! Please Help

[Anon]

I used the following ALTER table command:
ALTER TABLE test
ADD constraint test_key
PRIMARY KEY (id);

and this is the error i get:

Error - /opt/pgadmin/phpPgAdmin/sql.php -- Line: 107
PostgreSQL said: ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented for that constraint type.
Your query:
ALTER TABLE test
ADD constraint test_key
PRIMARY KEY (id)

Please help !!!

[toma42]

er, what kind of constraint are you trying to make; just the primary key? Use an index for that, I believe.

[chriskl]

PostgreSQL doens't support the ADD PRIMARY KEY sql function. (I am actually working on a patch at the moment to enable this - it should be in 7.2)

However, you can do this instead:

CREATE UNIQUE INDEX "test_pkey" ON test(id);

Plus, the "id" column in the "test" table MUST be NOT NULL for it to be a proper Primary Key.

You can then modify the pg_index table and set its entry to 'indisprimary' if you like.

Chris