This may be well-known or uninteresting, but slony 1.1.2 fails to
replicate from Pg 7.3.4 due to a typo ("comment comment") in rev
1.7.2.1 of slony1_funcs.v73.sql (Sep2005?). The typo causes a
transaction to fail and cascades to other issues. Jan fixed the
typo in the patch below on Thursday, but without comment.
Ed
On Thursday November 10 2005 4:40 pm, CVS User Account wrote:
> Log Message:
> -----------
> Disable indexes by setting pg_class.relhasindex to false
> during the initial COPY on subscribing to a set. The indexes
> are rebuild via REINDEX at the end of the copy operation.
>
> Also try to truncate the relation before the copy on 8.0 and
> later. Catch an eventual exception (foreign keys) and fallback
> to a delete.
>
> Jan
>
> Tags:
> ----
> REL_1_1_STABLE
>
> Modified Files:
> --------------
> slony1-engine/src/backend:
> Makefile (r1.19 -> r1.19.2.1)
> slony1_funcs.sql (r1.64.2.12 -> r1.64.2.13)
> slony1_funcs.v73.sql (r1.7.2.1 -> r1.7.2.2)
> slony1_funcs.v74.sql (r1.6.2.1 -> r1.6.2.2)
> slony1-engine/src/slon:
> remote_worker.c (r1.86.2.9 -> r1.86.2.10)
> slony1-engine/src/slonik:
> slonik.c (r1.42.2.2 -> r1.42.2.3)
> slony1-engine/src/xxid:
> Makefile (r1.17 -> r1.17.2.1)
>
> Added Files:
> -----------
> slony1-engine/src/backend:
> slony1_base.v80.sql (r1.1.2.1)
> slony1_funcs.v80.sql (r1.1.2.1)
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general