John P Weatherman <jweatherman91@xxxxxxxxxxxxxx> writes: > 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. At least in Postgres, there is no such animal as a PK (or unique) constraint without an underlying index. Maybe you'd better be more clear about what problem you're having. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
