Re: reindexing keys in postgres - Mailing list pgsql-general

From Bill Moran
Subject Re: reindexing keys in postgres
Date
Msg-id 20070406161006.671cf6eb.wmoran@potentialtech.com
Whole thread Raw
In response to reindexing keys in postgres  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
List pgsql-general
In response to "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>:

> Hi,
> Lately i was searching for a way I could reindex all my keys. Primary Keys
> in particular.
> Really didn't find any manual that could guide me through.
>
> Reason i wanted to reindex my PK is that whenever i insert a record in the
> table, even though that record is unique, i get an error saying violation of
> primary key.
> So i thought of reindexing my keys.
>
> Can anyone give me pointers for the same

http://www.postgresql.org/docs/8.2/static/sql-reindex.html

--
Bill Moran
http://www.potentialtech.com

pgsql-general by date:

Previous
From: "Harpreet Dhaliwal"
Date:
Subject: reindexing keys in postgres
Next
From: Bill Moran
Date:
Subject: Re: Help!! Crash recovery