Re: [GENERAL] Rebuilding Primary Key???

psql database
 drop index table_pkey;
 create unique index table_pkey on table (field1, fiel2);
 \q



Tim Perdue wrote:
>
> How in the world do you rebuild the primary key table in Postgres?
>
> I've sent a few messages to hackers and don't get much response, but in a
> nutshell, there is a problem with pgsql in that sometimes you can get
> duplication in the primary key.
>
> I eliminated the duplicates from the table today, but postgres still is
> confused.
>
> Basically, I want to rebuild that _pkey table that postgres creates.
>
> Tim Perdue
> PHPBuilder.com / GotoCity.com / Geocrawler.com

--
------------------------------------------------------------
Thomas Reinke                            Tel: (416) 460-7021
Director of Technology                   Fax: (416) 598-2319
E-Soft Inc.                         http://www.e-softinc.com