reindexing keys in postgres - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject reindexing keys in postgres
Date
Msg-id d86a77ef0704061251r73a4b9cbv7d668c357427fc70@mail.gmail.com
Whole thread Raw
Responses Re: reindexing keys in postgres  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
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

Thanks,
~Harpreet

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL WHERE: many sql or large IN()
Next
From: Bill Moran
Date:
Subject: Re: reindexing keys in postgres