PKs without indexes
От | John P Weatherman |
---|---|
Тема | PKs without indexes |
Дата | |
Msg-id | 1303209946.7538.12.camel@darkflame.weatherman.net обсуждение исходный текст |
Ответ на | Orphan Temp Table After PITR (Selva manickaraja <mavles78@gmail.com>) |
Ответы |
Re: PKs without indexes
Re: PKs without indexes |
Список | pgsql-admin |
Hi all, I am attempting to set up slony-i and have run into a minor glitch...apparently whoever designed the database I have inherited didn't consistently build indexes to go along with Primary Keys, or at least that's the error message I have been getting. I am far from confident in my own sqlfu in the catalog tables. Does anyone have a script for identifying tables without indexes that correspond to their PKs? I'm just trying to avoid re-inventing the wheel if I can help it. Thanks, John John P Weatherman Sr Database Administrator Centerstone
В списке pgsql-admin по дате отправления: