From: John P Weatherman <jweatherman91@alumni.wfu.edu>
To: pgsql-admin@postgresql.org
Cc: john.weatherman@centerstone.org
Subject: Re: PKs without indexes
Date: Tue, 19 Apr 2011 20:59:16 -0500
Message-ID: <1303264756.7538.15.camel@darkflame.weatherman.net> (raw)
In-Reply-To: <594449.61680.qm@web39702.mail.mud.yahoo.com>
References: <594449.61680.qm@web39702.mail.mud.yahoo.com>
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 = current_schema()
> and relkind = 'r'
> and c.oid not in (
> select indrelid
> from pg_index
> where indisprimary or indisunique
> )
> order by 1;
>
> Bob Lunney
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jweatherman91@alumni.wfu.edu, john.weatherman@centerstone.org
Subject: Re: PKs without indexes
In-Reply-To: <1303264756.7538.15.camel@darkflame.weatherman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox