Rebuilding Primary Key??? - Mailing list pgsql-general

From Tim Perdue
Subject Rebuilding Primary Key???
Date
Msg-id 002d01beb865$d7f1d370$0b8c5aa5@timnt.weather.net
Whole thread Raw
List pgsql-general
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




pgsql-general by date:

Previous
From: "John M. Flinchbaugh"
Date:
Subject: Re: [GENERAL] initdb in 6.5 not creating 'postgres' db
Next
From: lynch@cognitivearts.com (Richard Lynch)
Date:
Subject: Old Versions?