On 24/03/17 02:00, Peter Eisentraut wrote:
> On 3/21/17 21:38, Peter Eisentraut wrote:
>> This patch is looking pretty good to me, modulo the failing pg_dump tests.
>>
>> Attached is a fixup patch. I have mainly updated some comments and
>> variable naming for (my) clarity. No functional changes.
> Committed all that.
>
Testing now this patch is in, I'm unable to create a subscription:
(master)
bench=# CREATE PUBLICATION pgbench FOR TABLE pgbench_accounts , pgbench_branches,
pgbench_tellers,pgbench_history WITH (PUBLISH INSERT, PUBLISH UPDATE, PUBLISH DELETE);
(slave)
bench=# CREATE SUBSCRIPTION pgbench CONNECTION 'port=5447 user=postgres dbname=bench' PUBLICATION pgbench
WITH (COPY DATA);
ERROR: duplicate key value violates unique constraint
"pg_subscription_rel_srrelid_srsubid_index"
DETAIL: Key (srrelid, srsubid)=(0, 16389) already exists.
This is a pair of freshly initdb'ed instances, the master has a size 100
pgbench schema.
I'm guessing this is a different bug from the segfault also reported
regards
Mark