Re: [ADMIN] PKs without indexes

2011-04-19 Thread John P Weatherman
Awesome! Thanks Bob. On Tue, 2011-04-19 at 12:51 -0700, Bob Lunney wrote: > > Slony will use any unique index on a table for replication purposes, so the > list of tables should come from: > > select relname > from pg_class c > join pg_namespace n on c.relnamespace = n.oid > where nspname

Re: [ADMIN] PKs without indexes

2011-04-19 Thread Bob Lunney
--- On Tue, 4/19/11, Jerry Sievers wrote: > From: Jerry Sievers > Subject: Re: [ADMIN] PKs without indexes > To: jweatherma...@alumni.wfu.edu > Cc: pgsql-admin@postgresql.org > Date: Tuesday, April 19, 2011, 11:19 AM > John P Weatherman > writes: > > > Hi all,

Re: [ADMIN] PKs without indexes

2011-04-19 Thread Jerry Sievers
John P Weatherman writes: > 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.

Re: [ADMIN] PKs without indexes

2011-04-19 Thread Tom Lane
John P Weatherman 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

[ADMIN] PKs without indexes

2011-04-19 Thread John P Weatherman
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