reindexing keys in postgres

Поиск
Список
Период
Сортировка
От Harpreet Dhaliwal
Тема reindexing keys in postgres
Дата
Msg-id d86a77ef0704061251r73a4b9cbv7d668c357427fc70@mail.gmail.com
обсуждение исходный текст
Ответы Re: reindexing keys in postgres
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL WHERE: many sql or large IN()
Следующее
От: Bill Moran
Дата:
Сообщение: Re: reindexing keys in postgres