Thread: 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
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