PKs without indexes - Mailing list pgsql-admin

From John P Weatherman
Subject PKs without indexes
Date
Msg-id 1303209946.7538.12.camel@darkflame.weatherman.net
Whole thread Raw
In response to Orphan Temp Table After PITR  (Selva manickaraja <mavles78@gmail.com>)
Responses Re: PKs without indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PKs without indexes  (Jerry Sievers <gsievers19@comcast.net>)
List 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 by date:

Previous
From: Alessio Gennari
Date:
Subject: Re: PL/Java
Next
From: Achilleas Mantzios
Date:
Subject: Re: PL/Java