Re: alter table ad primary key

Christoph Dalitz wrote:
> Hello,
>
> trying "alter table buecher add primary key (isbn);"
> gives the error "ALTER TABLE / ADD CONSTRAINT is not implemented"
> with PG 7.1.
>
> Does anybody know whether this works with a newer PG version?
>
> Did someone already implement a workaround in form of a stored
> procedure that does the following:
>   - copy the table entirely to a temporary table
>   - remember all indices, constraints, rules and triggers on the old table
>     (is that possible at all?)
>   - drop the old table
>   - recreate the table with a primary key
>   - copy the temp table bakc
>   - drop the temp table
> ?
>


You don't really need all this...

just:

create unique index buecher_isbn_pkey on buecher(isbn);
update pg_attribute set attnotnull='t' from pg_class where attrelid=oid and relname='buecher' and attname='isbn';

This will have exactly the same effect as making it a primary key. The *only* difference is that \d will not say it's a
primary
key... Functionally, it is completely the same thing though...

I hope, it helps...

Dima