I need to convert an existing unique index on a very heavily inserted table
into a primary key. Alter table works, but locks the table for too long.
As a hack, can I just set pg_index.indisprimary = 't' and
pg_constraint.contype = 'p' for the appropriate row in each? This is for
7.4.6 and 8.0beta3...
pgsql-general by date
|Next:||From: Geoffrey||Date: 2004-12-23 00:55:05|
|Subject: Re: What HW / OS is recommeded|
|Previous:||From: Klint Gore||Date: 2004-12-22 23:09:48|
|Subject: duplicate msgs when delivery through commandprompt.com|