Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 5D3FC1337BDE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 19 Apr 2011 07:45:57 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 08724-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 19 Apr 2011 10:45:51 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from elasmtp-spurfowl.atl.sa.earthlink.net
	(elasmtp-spurfowl.atl.sa.earthlink.net [209.86.89.66])
	by mail.postgresql.org (Postfix) with ESMTP id E2AFF1337BA6
	for <pgsql-admin@postgresql.org>; Tue, 19 Apr 2011 07:45:49 -0300 (ADT)
Received: from [66.128.249.226] (helo=[192.168.24.108])
	by elasmtp-spurfowl.atl.sa.earthlink.net with esmtpa (Exim 4.67)
	(envelope-from <jweatherman91@alumni.wfu.edu>) id 1QC8RH-0000AZ-Ey
	for pgsql-admin@postgresql.org; Tue, 19 Apr 2011 06:45:47 -0400
Subject: PKs without indexes
From: John P Weatherman <jweatherman91@alumni.wfu.edu>
Reply-To: jweatherman91@alumni.wfu.edu
To: pgsql-admin@postgresql.org
In-Reply-To: <BANLkTimxxeE_6rt=+5X8VynGUX7rvr51VA@mail.gmail.com>
References: <BANLkTimxxeE_6rt=+5X8VynGUX7rvr51VA@mail.gmail.com>
Content-Type: text/plain
Date: Tue, 19 Apr 2011 05:45:46 -0500
Message-Id: <1303209946.7538.12.camel@darkflame.weatherman.net>
Mime-Version: 1.0
X-Mailer: Evolution 2.12.3 (2.12.3-19.el5) 
Content-Transfer-Encoding: 7bit
X-ELNK-Trace: 
 b4d21b641634dbbe40ea0adc697db4f96818e31467099fba7ce20dc116722d2da9fd2ccb0302b5cc350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c
X-Originating-IP: 66.128.249.226
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201104/170
X-Sequence-Number: 37351

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