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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
