Search Postgresql Archives
reindexing keys in postgres
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: reindexing keys in postgres
- From: "Harpreet Dhaliwal" <harpreet.dhaliwal01@xxxxxxxxx>
- Date: Fri, 6 Apr 2007 15:51:03 -0400
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=Sz5KvJM6ZV1KeaouW/LGh3nw9To0VI57l/ffOkL7rFrvngHG2Ghz2N1e9j0cY/S6DGvO7GgICAuNNlBzBHJYd3Vcam2hYWhAYj9oqSdlpHdgWnWG7qjJtGTkOgKxj+muYi+aFOGevA1hXk0yeR2aQYPtGXsEqZh4GGfyJYOUJTo=
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]