reindexing keys in postgres

Started by Harpreet Dhaliwalabout 19 years ago2 messagesgeneral
Jump to latest
#1Harpreet 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

Thanks,
~Harpreet

#2Bill Moran
wmoran@potentialtech.com
In reply to: Harpreet Dhaliwal (#1)
Re: reindexing keys in postgres

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