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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PKs without indexes  (Jerry Sievers <gsievers19@comcast.net>)
Список 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 по дате отправления:

Предыдущее
От: Alessio Gennari
Дата:
Сообщение: Re: PL/Java
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: PL/Java