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
John P Weatherman jweatherma...@alumni.wfu.edu 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
--- On Tue, 4/19/11, Jerry Sievers gsiever...@comcast.net wrote:
From: Jerry Sievers gsiever...@comcast.net
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 jweatherma
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 =