Re: PKs without indexes

John P Weatherman <jweatherman91(at)alumni(dot)wfu(dot)edu> 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