Ericson Smith <eric(at)did-it(dot)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