Re: Recreating a primary key

Ericson Smith <eric@did-it.com> writes:
> Is there a way to re-create a primary key?

In 7.3, there's ALTER TABLE ADD PRIMARY KEY.  In earlier releases,
you'd have to fake it by manually poking pg_index.indisprimary
after you create a unique index.

            regards, tom lane