From: | Thomas Reinke <reinke(at)e-softinc(dot)com> |
---|---|
To: | Tim Perdue <tim(at)geocrawler(dot)com> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] Rebuilding Primary Key??? |
Date: | 1999-06-17 02:54:23 |
Message-ID: | 3768635F.B60F13FB@e-softinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Graf | 1999-06-17 05:54:07 | PL/pgsql problem in 6.5 |
Previous Message | Richard Lynch | 1999-06-17 02:39:52 | Old Versions? |