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
>
>