reindexing keys in postgres
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
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